Licence plate number new format

Hi everyone,

We need to change a format of licence plate number in cells.

from Old format
ZG1234AB
ZG123AB
ZG1234A
ZG123A

to New format
ZG 1234-AB
ZG 123-AB
ZG 1234-A
ZG 123-A

In some cases we have thre numbers and in others four numbers.
Otherwise we would change text to columns and then concatenate with " ", and "-".

Can anyone help with macro

You could try here in below link for text string manipulation.

https://www.ablebits.com/office-addi...-string-excel/

Welcome to the forum.

This isn't a macro, but will work. It assumes that the numbers always start with 2 letters and end with two letters. Use this formula (assuming original plate number in A2):

Formula:

Please Login or Register  to view this content.

Drag down until it converts all your data.
If you want to replace the old numbers with new, after doing this, select the results of the formulae, copy and then Paste Values over the top of the originals.

Hope that makes sense and does what you want.