A1 =127-0112

Try the formula in B1
="X" & MID(A1,2,LEN(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Tracey" wrote:

I need a formula that deletes and add:

Example: change

127-0112 to X27-0112

delete first character and replace with "X" or
replace first character with "X"

Tracey Harold