G
Guest
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.
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.