software

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,quot;Last Name',quot;Home Phonequot; ect.

Hope this make sense, I am not even sure what or how to ask...
Thank you for helping a excel newbe,

Phil

Experiment with this:
Select the cell with the long string in it.
Datagt;Text-to-Columns
Select: Delimited and play with the settings.

Remember: Editgt;Undo is your friend.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Philquot; wrote:

gt; www.officialenter.com/excel_.jpg
gt;
gt; This shows a picture of the issue I am having.
gt; How do I make this spreadsheet look the way that I am used to?
gt; With each field having a cell, not having:
gt; Field Name,quot;Last Name',quot;Home Phonequot; ect.
gt;
gt; Hope this make sense, I am not even sure what or how to ask...
gt; Thank you for helping a excel newbe,
gt;
gt; Phil

Use quot;Text to columnquot; please

quot;Philquot; gt; wrote in message
...
gt; www.officialenter.com/excel_.jpg
gt;
gt; This shows a picture of the issue I am having.
gt; How do I make this spreadsheet look the way that I am used to?
gt; With each field having a cell, not having:
gt; Field Name,quot;Last Name',quot;Home Phonequot; ect.
gt;
gt; Hope this make sense, I am not even sure what or how to ask...
gt; Thank you for helping a excel newbe,
gt;
gt; Phil
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.

PeteYes, 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?
quot;PY amp; Associatesquot; wrote:

gt; Use quot;Text to columnquot; please
gt;
gt; quot;Philquot; gt; wrote in message
gt; ...
gt; gt; www.officialenter.com/excel_.jpg
gt; gt;
gt; gt; This shows a picture of the issue I am having.
gt; gt; How do I make this spreadsheet look the way that I am used to?
gt; gt; With each field having a cell, not having:
gt; gt; Field Name,quot;Last Name',quot;Home Phonequot; ect.
gt; gt;
gt; gt; Hope this make sense, I am not even sure what or how to ask...
gt; gt; Thank you for helping a excel newbe,
gt; gt;
gt; gt; Phil
gt;
gt;
gt;

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

quot;Philquot; gt; wrote in message
...
gt; www.officialenter.com/excel_.jpg
gt;
gt; This shows a picture of the issue I am having.
gt; How do I make this spreadsheet look the way that I am used to?
gt; With each field having a cell, not having:
gt; Field Name,quot;Last Name',quot;Home Phonequot; ect.
gt;
gt; Hope this make sense, I am not even sure what or how to ask...
gt; Thank you for helping a excel newbe,
gt;
gt; Phil
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.

quot;Bernard Liengmequot; wrote:

gt; Try selecting column A and using Data | Text to Column
gt; You may also need to use Edit | Find and Replace to get rid of quotes
gt; The picture was very small!!!
gt; best wishes
gt;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Philquot; gt; wrote in message
gt; ...
gt; gt; www.officialenter.com/excel_.jpg
gt; gt;
gt; gt; This shows a picture of the issue I am having.
gt; gt; How do I make this spreadsheet look the way that I am used to?
gt; gt; With each field having a cell, not having:
gt; gt; Field Name,quot;Last Name',quot;Home Phonequot; ect.
gt; gt;
gt; gt; Hope this make sense, I am not even sure what or how to ask...
gt; gt; Thank you for helping a excel newbe,
gt; gt;
gt; gt; Phil
gt;
gt;
gt;

Okay... played with it some more.
Thank you all very much. I got it!
You all are the best!

quot;Philquot; wrote:

gt; Great... but do I have to now do that to each row? I have 5000
gt; Sorry about the pic, I didn't want to inclued the parts that had
gt; personal/private info.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt; gt; Try selecting column A and using Data | Text to Column
gt; gt; You may also need to use Edit | Find and Replace to get rid of quotes
gt; gt; The picture was very small!!!
gt; gt; best wishes
gt; gt;
gt; gt; --
gt; gt; Bernard V Liengme
gt; gt; www.stfx.ca/people/bliengme
gt; gt; remove caps from email
gt; gt;
gt; gt; quot;Philquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; www.officialenter.com/excel_.jpg
gt; gt; gt;
gt; gt; gt; This shows a picture of the issue I am having.
gt; gt; gt; How do I make this spreadsheet look the way that I am used to?
gt; gt; gt; With each field having a cell, not having:
gt; gt; gt; Field Name,quot;Last Name',quot;Home Phonequot; ect.
gt; gt; gt;
gt; gt; gt; Hope this make sense, I am not even sure what or how to ask...
gt; gt; gt; Thank you for helping a excel newbe,
gt; gt; gt;
gt; gt; gt; Phil
gt; gt;
gt; gt;
gt; gt;

Highlight all the data (CTRL-A) then Edit | Find amp; 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