View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Big Cat Big Cat is offline
external usenet poster
 
Posts: 2
Default How to insert hyphen "-" in between two numbers

Hi All:

I was wondering if one of you Excel guru's out there could coach me
through this challenge I have. I run an extract report from our
business system into Excel and I need to have a particular column of
data changed as follows:

From: 06001 To: 06-001

Is there a formula of some sort that I could write to handle inserting
the hyphen "-" in between the 2nd and 3rd character of my data column
to accomplish this?

Please help.

Thanks,

Big Cat