editing cells

[Guest]

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.

 

[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

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.

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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.