"Excel Data Problem - Space Between Word 2"

  • Thread starter Thread starter keong04
  • Start date Start date
K

keong04

Hi ! Anurag.d !
It's really work on what u provide ! But just help me to settle 50% o
my job only ! If all my data is create by 3 charaters & 4 number (ab
1234) , my job will finish ! But my data also have (ab 1234) , (satri
1234) , (kv 1234 t) , (putrajaya 123)......
How to do it ???
Anyway , thanks for ur help !

Hi ! Alfd !
Maybe im stupid in using excel ! Or u didnt see my thread very cleary
I really dun know how to use it ! My problems is space between word(ab
1234) in single cell !!
 
Hi
and what do you want to do with this data or do you simply
want to remove the spaces?. For the latter one simply
use 'Edit - Replace' and replace the space character
with 'nothing'
 
Hi!

To use find & replace in column A:

Highlight the whole column (click on the A at the top)
Press ctrl+F (both at the same time)
In the dialogue box which pops up enter a <SPACE> character in "Fin
what" (i.e. press the spacebar)
Click Replace
Make no entry in the Replace with text box
Click Replace all

It takes ALL spaces out of the selected cells, whether they look lik
abc 1234 or al df 456 or 1 2 3 456.

Try it on a sample worksheet.

Al
 
Back
Top