If anyone can help me in this I would be very greatful

We receive a list of codes like "TND4567". We manually put the dash
between the text and numbers. is there any way of doing it through a
formula in excel.

If your text is always 3 characters, then one way:

=LEFT(A1,3) & "-" & MID(A1,4,255)

where 255 is just a big number to ensure all the digits are captured.

In article .com,
"Accounts jobs" wrote:

If anyone can help me in this I would be very greatful

We receive a list of codes like "TND4567". We manually put the dash
between the text and numbers. is there any way of doing it through a
formula in excel.

If they are of a fixed format:

=LEFT(A1,3) &"-"& RIGHT(A1,4)

"Accounts jobs" wrote:

If anyone can help me in this I would be very greatful

We receive a list of codes like "TND4567". We manually put the dash
between the text and numbers. is there any way of doing it through a
formula in excel.

If your text always begin with TND then try this:

Select your data range then go to...
Edit Replace Find what: TND Replace with: TND- Replace All


"Accounts jobs" wrote:

If anyone can help me in this I would be very greatful

We receive a list of codes like "TND4567". We manually put the dash
between the text and numbers. is there any way of doing it through a
formula in excel.

If you ALWAYS need the dash inserted between
the 3rd and 4th characters ....

try something like this:

=REPLACE(A1,1,3,LEFT(A1,3)&"-")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Accounts jobs" wrote:

If anyone can help me in this I would be very greatful

We receive a list of codes like "TND4567". We manually put the dash
between the text and numbers. is there any way of doing it through a
formula in excel.

To be on the safe side, you could just use
=LEFT(A1,3) & "-" & MID(A1,4,Len(A1))

On Mar 29, 9:51 am, JE McGimpsey wrote:
If your text is always 3 characters, then one way:

=LEFT(A1,3) & "-" & MID(A1,4,255)

where 255 is just a big number to ensure all the digits are captured.

In article .com,
"Accounts jobs" wrote:

If anyone can help me in this I would be very greatful

We receive a list of codes like "TND4567". We manually put the dash
between the text and numbers. is there any way of doing it through a
formula in excel.

True, but I hesitate to add the overhead of another function where it's
not needed. The recalc would be much faster using

MID(A1,4,32763)




In article . com,
"meatshield" wrote:

To be on the safe side, you could just use
=LEFT(A1,3) & "-" & MID(A1,4,Len(A1))

On Mar 29, 9:51 am, JE McGimpsey wrote:
If your text is always 3 characters, then one way:

=LEFT(A1,3) & "-" & MID(A1,4,255)

You make a good point. =)

On Mar 29, 4:20 pm, JE McGimpsey wrote:
True, but I hesitate to add the overhead of another function where it's
not needed. The recalc would be much faster using

MID(A1,4,32763)

In article . com,

"meatshield" wrote:
To be on the safe side, you could just use
=LEFT(A1,3) & "-" & MID(A1,4,Len(A1))

On Mar 29, 9:51 am, JE McGimpsey wrote:
If your text is always 3 characters, then one way:

=LEFT(A1,3) & "-" & MID(A1,4,255)