[mso] Word, Excel & txt files

  • From: Glenda Wells <gwells@xxxxxxxxxxx>
  • To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
  • Date: Tue, 21 Jan 2003 15:38:44 -0500

I have data via Terminal Services that I need to work on in Word then Excel.
 
I can save the data in CSV which has been working great, I've even made some
IF and nested IF statements to get the data the way I want it.
 
However, one field has multiple items in it and it's not always the same
number of items in the field.
 
Saving the data in CSV doesn't seem to work so I made a table which stores
the multiple pieces of data in one field which would be OK but when I
copy/paste to Excel, it creates a merged field which won't allow me to do
anything such as sort the data.
 
I guess what I want to ask is...is there a way to save a multiple value
field in CSV so it creates multiple columns?
 
If not that, what other options may be available?  This thing with the
merged field is seriously limiting me.
 
Thanks.  /g


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: