editing cells

G

geza

I am looking for help as follows: in a column of several thousand cells, how can I delete the space(s) preceding the text (or numeric) value in some cells. Doing it one by one is practically impossible. I tried manipulating both the concatenate and the text to column functions but they didn't work - unless I used them erroneously. Thank you.
 
J

Jason Morin

You can use TRIM:

=TRIM(A1)

or download a macro from MVP David McRitchie's website:

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

HTH
Jason
Atlanta, GA
-----Original Message-----
I am looking for help as follows: in a column of several
Click to expand...
thousand cells, how can I delete the space(s) preceding
the text (or numeric) value in some cells. Doing it one
by one is practically impossible. I tried manipulating
both the concatenate and the text to column functions but
they didn't work - unless I used them erroneously. Thank
you.
 
F

Frank Kabel

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards
Frank Kabel
Frankfurt, Germany

geza said:
I am looking for help as follows: in a column of several thousand
Click to expand...
cells, how can I delete the space(s) preceding the text (or numeric)
value in some cells. Doing it one by one is practically impossible.
I tried manipulating both the concatenate and the text to column
functions but they didn't work - unless I used them erroneously. Thank
you.
 
Top