VBA to delete leading space
On Jan 17, 10:54 am, CB wrote:
I have a column of data that has a leading blank in each cell. Does someone
have a code example that I can use to delete this leading space? I have
spaces between data in these cells and just need to delete the leading space
on the left hand side of each cell. Any and all replies are greatly
appreciated.
In an adjacent column use this formula
=Right("RefCell', Len("RefCell") - 1)
That should lop off the leading blank.
SteveM
|