Thread: Want to split 922 037 022 into 3cols and recombine without spaces
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 Want to split 922 037 022 into 3cols and recombine without spaces
Try

=SUBSTITUTE(A1," ","")

Mike

"Confused" wrote:

I have some employee numbers in the format 923 022 033. I want to put the
numbers together without spaces. I split into cols and then recombined but
the leading zeros were missing. So instead of getting 922037022 I get
9232233. Any solution
Reply With QuoteReply With Quote