Take the space out of text?????

  • Thread starter Thread starter nicholeslusser
  • Start date Start date
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
 
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 **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help, I'm Desperate!!!!!!! 4
text formatting question 18
Excel Subtract text after the third space and before the fourth (from between spaces) 3
Pullng data out of string of text 4
Tough One!! 4
Excel wrapped rows, want automatically leave some space bottom of 1
Find position number of third space 6
Exporting As Text with X Number of Spaces Between Data 3

Back
Top