[mso] Re: Word, Excel & txt files
- From: Glenda Wells <gwells@xxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Tue, 21 Jan 2003 16:29:23 -0500
I DO mean cell in Word, sorry for mixing my terminology here...Word, Excel,
Access...I'm SOOOO confooosed!
Merge cells is not active and the odd thing is that the field in question
appears on a second row with all the other cells in that row empty. The
following row begins the new record. Weird.
I usually don't have a problem getting the data but sometimes multiple
option fields such as this are difficult and I've never seen this particular
problem before.
I've downloaded & converted about 20 times today...always the same data set
just to be sure nothing else is going on. Without the multiple field, the
data converts beautifully. If I add this field it's messed up.
FYI, the data in question is a list of missing items so one record may have
2 missing items, the next only 1, the next 3, the next 7, the next 0 and so
on. I don't particularly care if the list is separated by commas or if it
just reads as one long string for that matter, but I hate a problem like
this and can't let it go.
Any other ideas you may have would be most welcome.
g
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, January 21, 2003 4:02 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Word, Excel & txt files
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
*************************************************************
*************************************************************
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:
