Change 2 lined/wraped cell to 1 line

[ananthram]

Hi,


i have a file with 4k of data which has warped cells with 2 lines in it please help me with making it 1 liner so that when i copy and paste it to external source it should be in 1 line. Please find the below file for sample data


https://www.box.com/s/6pyl2ywhnhsv6rht6pb8

 

[Faseeh]

Hi Ananthram,


Please try:

=SUBSTITUTE(A1,CHAR(10),"")

Regards,

 

[ananthram]

wow awesome sir between can u please explain me the above formula. if you dont mind.

 

[Faseeh]

You are welcome, Sure. When you press Atl+Enter, a new line is started within the cell, this new line is identified as CHAR(10), it has a proper name (i think it is called carriage return). So just replace this character with ("") and it is done.


Faseeh

 

[ananthram]

Great thank you sir you made my day