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.