EXCEL expert?
I imported a cell into EXCEL that says:
'726 followed by two spaces
I want to convert it to represent the value 726. I'm pretty good in EXCEL but can't find the way to trim the two spaces and convert the text to a value.
If you know how, share your response here publicly to help me, and to show the Biznik community that you're the go-to person for EXCEL projects.
Thanks!
