"Excel Data Problem - Space Between Word"

K

keong04

Hi ! EVERYBODY ! Im new guy in this forum !

I HAVE A BIG PROBLEM IN EXCEL ! IF ANY1 CAN HELP ?

IM USING MS EXCEL 2000(9.0.3821 SR-1)

MY PROBLEM IS SPACE BETWEEN WORD IN SINGLE CELL (1 COLUMN)!

EXAMPLE : ABC 1234 , AB 1234 , PUTRA 1234 , KV 1234 T ...

CAN I MAKE ALL THE SPACE GONE ?

I WANT TO MAKE

EXAMPLE : ABC 1234 > ABC1234
AB 1234 > AB12
PUTRA 1234 > PUTRA1234
KV 1234 T > KV1234T

THANKS A LOT FOR ANYONE CAN GIVE HELP !!!
VERY URGENT !!! I HAVE 60,000+ DATA , IT TAKE TIME TO CHANGE 1 BY 1 !!

Attachment filename: sample.bmp
Download attachment: http://www.excelforum.com/attachment.php?postid=54446
 
F

Frank Kabel

Hi
first: please turn off your CAPS-Lock: Difficult to read and considered
as shouting in newsgroups.

For your question: Try: 'Edit - Replace' and replace a space with
nothing
 
A

anurag.d

Hi,
Select the column containing ur data.
Go to Data,Text to columns.
I assume ur aware abt how to use it.
The above procedure will split ur data into two parts.
eg: 1 abc in A column will become 1 in column A and abc in column
 
A

AlfD

Hi!

Alternatively use find|replace.

Find " " (put in a space without the quote marks)
Replace with "" (put in nothing at all)
Check Look in Values.
Click Replace all.

Al
 
Top