formula to eliminate space in a cell - Used trim doesn't work

[melvin]

Hi all,

trying to overcome a space in cell a cell, using trim doesn't really help, as once I do paste values of trim brings back to the same result.

Thanks

Melv.

 

[Hui]

Melv

in C6: =TRIM(SUBSTITUTE(B6,CHAR(10),""))

Char(10) is a Carriage Return, which is why it takes up 2 lines

 

[ashish mehra]

Hi Melvin,

Try this

=TRIM(SUBSTITUTE(B6,CHAR(10),""))

Regards,
AM

 

[melvin]

Thanks mate, that works perfect.

Have a great day mate.

Melv.