TRIM()

[donh]

Hi Hope you can help!

Following on from a recent post I want to identify if a space has been
used in cell. I tried using Trim() but found it leaves the space I
want to remove.

Any help appreciated as always.

Regards

DonH

 

[Roger Govier]

Hi

Try
=SUBSTITUTE(A1," ","")

 

[donh]

Many thanks Roger.

Don