I cannot figure out how to remove one blank space in front of a text in column D to turn it into a number.
This seems like it should be simple but i've tried looking up different tricks, none of them seem to work. Find/Replace, Trim, substitute won't work.
Cell D2
"*225.00"
I'm out of ideas.
Bookmarks