Awesome guys ... Thanks.

Michael


"Glenn" wrote in message
...
Michael wrote:
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



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