Concatenate an Hyphen

M

Michael

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
 
G

Glenn

Michael said:
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
Click to expand...

=LEFT(A1,2)&"-"&MID(A1,3,9999)
 

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

Similar Threads

explorer.exe crashes 4
Svhost.exe bug relapse from SP2 [1/2] 0
Runtime Error when cursor is on an html file in Windows Explorer 1
Outlook crashes with Outlook connector 2002 0
Outlook connector crashes outlook 0

Top