Help, I'm Desperate!!!!!!!

[nicholeslusser]

I have exported some information into a excel spreadsheet that I will b
importing into another program. Unfortunately one of the colums has
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 nee
to be changed.

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

Thank you,

Nichol

 

[Frank Kabel]

Hi
why not use 'Edit - Replace' and replace a space with nothing

 

[nicholeslusser]

what do i ask it to "find"
and what do I ask it to "replace" with?????


nichol

 

[Frank Kabel]

Hi
for the find dialog simply hit the spacebar. The replace box remains
untouched

 

[c]

Just hit the spacebar when you are in the find field, and leave the replace
field empty. It works fine.

Chris