How to get Data in single line From new lines

[naveenmarapaka]

Dears I am not sure whether Iam giving you the right information to make you understand my problem

My issue is , In my Excel data , data is showing in new lines in fx bar
I dont know why

it is like space is there between each line, when i am deleting the space in FX bar after each line end
then it is joining in same line.

for clear understadning my issue.
pls refer attachements.


see the data of A1,A2,A3,A4,A5 in Formula bar , All are showing in new lines Except A4

the result is want is same like data in A4, how to get it.

[:) Sixthsense :)]

Because the user has given Alt+Enter to create new lines in the cell for each entry.

In B1 Cell
=SUBSTITUTE(A1,CHAR(10)," ")

Drag it down…

Copy the formula cells and use paste special and change it to values.

[naveenmarapaka]

Wonderful, Thank you so much for solving in a flash

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback