How to insert hyphen "-" in between two numbers

B

Big Cat

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
 
G

Guest

Hi,

As long as it's always in between second and third characters this should
work:

=REPLACE(A1,3,0,"-")

where A1 contains the original text
 
R

Ron Rosenfeld

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

1. You could custom format the column:
Format/Cells/Number/Custom Type: 00-000

2. You could use the formula:

=TEXT(A1,"00-000")


--ron
 
B

Big Cat

Ron,

Thanks for the help. I found it easiest to go with option 1 to solve
my problem immediately. If I wanted to use option 2 (formula), where
would I insert the formula in the list?

Please advise.

Thanks,

Big Cat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top