I need to remove an extra space in a cell (ex. cell a1 is 5543 and a space) it is set as general not a number, I have over 5700 rows, doing it manually is impossible can i do it? in a formula?
If it is just a trailing space you can use edit>replace find what put a
space and leave replace with
blank. If they are numbers copied from the web you can click in the find
what box, then hold
down alt while typing 0160 on the numpad, then release alt, leave replace
with blank. Finally if this is done on a regular basis see:
space) it is set as general not a number, I have over 5700 rows, doing it
manually is impossible can i do it? in a formula?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
