removing a space

[Guest]

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?

 

[Peo Sjoblom]

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:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

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?