# How to insert hyphen "-" in between two numbers

Big Cat
Guest
Posts: n/a

 24th Jul 2006
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?

Thanks,

Big Cat

=?Utf-8?B?Sm9zaCBDcmFpZw==?=
Guest
Posts: n/a

 24th Jul 2006
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

Ron Rosenfeld
Guest
Posts: n/a

 24th Jul 2006
On 23 Jul 2006 22:52:22 -0700, "Big Cat" <(E-Mail Removed)> wrote:

>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?
>
>
>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

Big Cat
Guest
Posts: n/a

 6th Aug 2006
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?

Thanks,

Big Cat

Ron Rosenfeld wrote:
> On 23 Jul 2006 22:52:22 -0700, "Big Cat" <(E-Mail Removed)> wrote:
>
> >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?
> >
> >
> >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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Janet Microsoft Outlook Contacts 1 19th Jun 2009 06:12 PM Jacqueline Microsoft Excel Misc 1 17th Jun 2009 07:44 PM =?Utf-8?B?TWVyZWRpdGg=?= Microsoft Word Document Management 2 18th Nov 2005 10:58 PM =?Utf-8?B?YmFqdQ==?= Microsoft Excel Misc 6 9th Feb 2005 03:15 PM Lynn Trapp Microsoft Access Getting Started 0 15th Sep 2004 09:15 PM

Features