So what is the current line separator?
That is, what are you replacing with CrLf ?

--
Tim Williams
Palo Alto, CA


"LMI" wrote in message
...
I have an export format coming over from my hand help device that is
coming
over in .csv when i open it up in excel my format is as follows:
date,time,value,shift
date, time,value,shift
date,time,value,shift
date,time value shift

How i need it to come over is this way:

date,time,value,shift[]date,time,value,shift[],date,time,value,shift.......

The[]is the CRLF how can i set the above format up running an excel macro?