How to join word in one cell
 

I need help to join word in one cell. For example in cell is AB 1234567 and I
need in another cell AB1234567, without spaces between letters and numbers.
Probably its a stupid question, but I desperately need help.

How to join word in one cell
 

Try this

=SUBSTITUTE(A1," ","")

Mike

"Nik" wrote:

I need help to join word in one cell. For example in cell is AB 1234567 and I
need in another cell AB1234567, without spaces between letters and numbers.
Probably its a stupid question, but I desperately need help.

How to join word in one cell
 

=SUBSTITUTE(A2," ","")


--
__________________________________
HTH

Bob

"Nik" wrote in message
...
I need help to join word in one cell. For example in cell is AB 1234567 and
I
need in another cell AB1234567, without spaces between letters and
numbers.
Probably it's a stupid question, but I desperately need help.

How to join word in one cell
 

Thanks so much!!!!!