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)