Hi
I am trying to remove leading 000000's on some data.
I had thought that I could use find and replace, but the replace column requires something to be entered for it to reflect.
I have tried " " to insert a space with the idea that I would then remove the leading spaces, but that doesn't appear to work.
Can anyone advise a better way to remove these? This is not for every row, as not all rows have these 000000's in the reference.
See attached for context
Thanks
Carlyn
Solved! Go to Solution.
Thank you that worked a treat!
Use a formula tool and apply the expression ReplaceChar([Target column], "Target column","Replacement char")