Remove gaps in lines of text ?

[Maverick27]

How do I remove the 'Gaps' in Col B of my Excel Sheet ?

Screenshot Link

https://ibb.co/mU1Udy

Anyone care to share Excel Function or Code, instead of doing it manually ?

Thanks in Advance.

 

[steve the fish]

Theres a chance this will work:

Highlight column
Press CTRL-H
Go to Find What box
Press CTRL-J
Press Replace All

 

[Maverick27]

Theres a chance this will work:

Highlight column
Press CTRL-H
Go to Find What box
Press CTRL-J
Press Replace All

Unfortunately, did'nt work.

TRIM Function also did'nt work !

 

[steve the fish]

Try something like this and see if they go:

=SUBSTITUTE(SUBSTITUTE(B1,CHAR(10),""),CHAR(13),"")

 

[Maverick27]

Try something like this and see if they go:

=SUBSTITUTE(SUBSTITUTE(B1,CHAR(10),""),CHAR(13),"")

Cheers - this worked !!