Take the space out of text?????

N

nicholeslusser

I have exported some information into a excel spreadsheet that I will be
importing into another program. Unfortunately one of the colums has a
space between the text that I need to remove.

Example:

how cell looks now: abcde fghij
how I need it to look: abcdefghij

Unfortunately it is not a small worksheet. It has 5863 rows that need
to be changed.

PLEASE!!!! PLEASE!!!! HELP!!!!!! If anyone can help I would greatly
appreciate it!!!!!!!!!

Thank you,

Nichole
 
P

Paul B

nicholeslusser, edit, replace, replace what put a space, replace with leave
blank
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Top