I am a novice on some or most of Excel commands, so I do not have an idea as
to how to do what you are asking.
I wish there was a way to attach a partial file that i am having trouble with.
All of the info for each company in in one cell.


"Pete_UK" wrote:

As long as you have no commas in the company name, you could try this:

=CHAR(34)&LEFT(A1,SEARCH(",",A1)-1)&CHAR(34)&MID(A1,SEARCH(",",A1),255)

Copy the formula down for as many entries as you have in column A. Then
highlight all the cells with this formula in and fix the values
(<copy, Edit | Paste Special | Values (check) | OK then <Enter). You
could then delete column A.

Hope this helps.

Pete


On Jan 25, 10:25 pm, Jeffrey
wrote:
I have a comma delimited file that opens up in Excel.
I need to add a quote character in the beginning of one cell.
Sample of what it looks like now: (all info is one cell such as A1)

this is in Cell A1
company name,"address","","city","state","zip"
this is in Cell A2
company name,"address","","city","state","zip"

I need it to look like this
Cell A1
"company name","address","","city","state","zip"
Cell A2
"company name","address","","city","state","zip"

Please note that the file has 2500 lines.