View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael[_2_] Michael[_2_] is offline
external usenet poster
 
Posts: 9
Default Concatenate an Hyphen

Hi Folks - I have account numbers that look like this:


10000000-03108-111-20-2102-52207-1200
10000001-03109-111-10-0000-52207-1200
10000002-03109-111-10-1600-52207-1200

etc....

What's the easist way to insert an hyphen after the first 2 digits so things
look like this:

10-000000-03108-111-20-2102-52207-1200
10-000001-03109-111-10-0000-52207-1200
10-000002-03109-111-10-1600-52207-1200

Thanks,

Michael