[mso] Re: Word, Excel & txt files
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 21 Jan 2003 16:01:43 -0500
When you say the data is stored as multiple pieces in one "field" (do you
mean "cell"?) in Word, what do you mean? Try highlighting all the data
inside that cell in Word and go to the Table menu and see if Merge cells is
active...if it is, then this is actually more than one cell in Word and if
so, choose Merge cells and it will convert it into one cell which you can
then copy into Excel (I'm assuming this is so, since Excel is seeing this
as merged cells, which I don't understand)
Nope...there really isn't any way to make Excel or Word recognize that you
want some data that is delimited by commas or spaces or whatever, in a
different way than it sees the rest.
Generally, what I do is open the csv file in Word, then convert the table to
text, then use Word's find and replace (since Excel's find/replace is too
limited) to get rid of the extraneous characters that are causing the stuff
to go into the wrong column, then convert it back to a table, then
copy/paste the whole table back into Excel. It's a pita, but it's the best
way I've found when the data comes in with all that weird formatting.
Good luck..it's a learning process for sure.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Glenda Wells
Sent: Tuesday, January 21, 2003 3:39 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Word, Excel & txt files
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:
