how to include dash within a cell

[Accounts jobs]

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.

 

[JE McGimpsey]

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.

 

[Guest]

If they are of a fixed format:

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

 

[Guest]

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

 

[Guest]

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

 

[meatshield]

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

 

[JE McGimpsey]

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)

 

[meatshield]

You make a good point. =)

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)