Hi everyone,
Got a problem.
I have 100 text files that i combine into 1 csv file. Text files ar
single quote separated and comma seperated, it looks like this

'105139.002','3','PANEL LAYOUT & WIRING','

This is fine, as soon as it becomes a CSV file i remove all the singl
quotes and it's all good. But i get a problem when i encounter
regular comma inside the text, like this:

'105139.002','3','PANEL LAYOUT, WIRING','

Notice after Layout there is a comma, but I don't want that to be in
separate cell.
So I'm trying to figure out something along the lines of this logic.
Look in cell D1
if last character is ' then skip to next one
if last character is not, then name that cell A
Go to the right one cell
if that cell has a ' at the end, then call it a B, and combine A
B
if that cell does not have a ' then name it b and go to next cell t
the right
then i need to delete all the left overs after i combine.
Please help me with coding.
Thanks,
Viktor

--
Vikxce
-----------------------------------------------------------------------
Vikxcel's Profile: http://www.excelforum.com/member.php...fo&userid=1860
View this thread: http://www.excelforum.com/showthread.php?threadid=49564