View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.