I have a column of text, some having leading spaces. I must remove all leading spaces.
I have tried =trim(cell), but it does not remove them. I then tried
=trim(clean(cell)) thinking that there might be some unprintables lurking.
That also does not work. I can manually remove the leading spaces, so I can see them [or the lack of them], but Excel does not seem to be able to work as needed.
Am I doing something wrong? It seems Trim should work.
I would MOST appreciate any thoughts or solutions.