parscon
11-20-2012, 06:53 AM
I have a some data on my excel file .
Now I want to add a comma to first of each line on cell and after that remove the lines and all data an each cell will be in 1 line on that cell
if I have data on cell A1 like this
DAT-565912
Replaced No
20405503
11700352
ZM2906923
I want A1 to be (added comma and removed the line break )
DAT-565912,Replaced No,20405503,11700352,ZM2906923
Thank you
Now I want to add a comma to first of each line on cell and after that remove the lines and all data an each cell will be in 1 line on that cell
if I have data on cell A1 like this
DAT-565912
Replaced No
20405503
11700352
ZM2906923
I want A1 to be (added comma and removed the line break )
DAT-565912,Replaced No,20405503,11700352,ZM2906923
Thank you