Thread: Want to split 922 037 022 into 3cols and recombine without spaces
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Want to split 922 037 022 into 3cols and recombine without spaces
Try
=SUBSTITUTE(A1," ",)

If this post helps click Yes
---------------
Jacob Skaria


"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