Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
http://www.officialenter.com/excel_.jpg
This shows a picture of the issue I am having. How do I make this spreadsheet look the way that I am used to? With each field having a cell, not having: Field Name,"Last Name',"Home Phone" ect. Hope this make sense, I am not even sure what or how to ask... Thank you for helping a excel newbe, Phil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
Experiment with this:
Select the cell with the long string in it. DataText-to-Columns Select: Delimited and play with the settings. Remember: EditUndo is your friend. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Phil" wrote: http://www.officialenter.com/excel_.jpg This shows a picture of the issue I am having. How do I make this spreadsheet look the way that I am used to? With each field having a cell, not having: Field Name,"Last Name',"Home Phone" ect. Hope this make sense, I am not even sure what or how to ask... Thank you for helping a excel newbe, Phil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
The picture is not very good, but you seem to have all the data in
column A, with commas separating the fields. To get all the data into separate columns, highlight column A then Data | Text to Columns and specify comma as the delimiter. Hope this helps. Pete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
Use "Text to column" please
"Phil" wrote in message ... http://www.officialenter.com/excel_.jpg This shows a picture of the issue I am having. How do I make this spreadsheet look the way that I am used to? With each field having a cell, not having: Field Name,"Last Name',"Home Phone" ect. Hope this make sense, I am not even sure what or how to ask... Thank you for helping a excel newbe, Phil |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
Yes, that seems to do the trick....
But how do I get rid of the commas and quotes? Plus what do I do if I need to apply this to 5000 rows? :( "PY & Associates" wrote: Use "Text to column" please "Phil" wrote in message ... http://www.officialenter.com/excel_.jpg This shows a picture of the issue I am having. How do I make this spreadsheet look the way that I am used to? With each field having a cell, not having: Field Name,"Last Name',"Home Phone" ect. Hope this make sense, I am not even sure what or how to ask... Thank you for helping a excel newbe, Phil |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
Try selecting column A and using Data | Text to Column
You may also need to use Edit | Find and Replace to get rid of quotes The picture was very small!!! best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Phil" wrote in message ... http://www.officialenter.com/excel_.jpg This shows a picture of the issue I am having. How do I make this spreadsheet look the way that I am used to? With each field having a cell, not having: Field Name,"Last Name',"Home Phone" ect. Hope this make sense, I am not even sure what or how to ask... Thank you for helping a excel newbe, Phil |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
Great... but do I have to now do that to each row? I have 5000 :(
Sorry about the pic, I didn't want to inclued the parts that had personal/private info. "Bernard Liengme" wrote: Try selecting column A and using Data | Text to Column You may also need to use Edit | Find and Replace to get rid of quotes The picture was very small!!! best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Phil" wrote in message ... http://www.officialenter.com/excel_.jpg This shows a picture of the issue I am having. How do I make this spreadsheet look the way that I am used to? With each field having a cell, not having: Field Name,"Last Name',"Home Phone" ect. Hope this make sense, I am not even sure what or how to ask... Thank you for helping a excel newbe, Phil |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
Okay... played with it some more.
Thank you all very much. I got it! You all are the best! "Phil" wrote: Great... but do I have to now do that to each row? I have 5000 :( Sorry about the pic, I didn't want to inclued the parts that had personal/private info. "Bernard Liengme" wrote: Try selecting column A and using Data | Text to Column You may also need to use Edit | Find and Replace to get rid of quotes The picture was very small!!! best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Phil" wrote in message ... http://www.officialenter.com/excel_.jpg This shows a picture of the issue I am having. How do I make this spreadsheet look the way that I am used to? With each field having a cell, not having: Field Name,"Last Name',"Home Phone" ect. Hope this make sense, I am not even sure what or how to ask... Thank you for helping a excel newbe, Phil |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not Sure How to Fix
Highlight all the data (CTRL-A) then Edit | Find & Replace (or CTRL-H).
In the Find box enter the character(s) you want to find, and leave the Replace With box empty, then click Replace All. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|