RemoveLeadingSpace

[gh]

There is a space before the first character of text, in each cell. How
can I remove the space?

TIA

[Paul]

Function:
=Trim(CellRef) e.g. =Trim(A1)

Code:

Sub Trim
trim(Range.text)
End Sub

e.g

Sub TrimText
Trim (Range("A:A").Text)
End Sub

"gh" <gh@at.ne> wrote in message
news:uMwBB8bmFHA.3656@TK2MSFTNGP09.phx.gbl...
> There is a space before the first character of text, in each cell. How
> can I remove the space?
>
> TIA