VBA Macro solution needed to replace a particular character under specific circumstances

[Scepticseeker]

I have a huge list of identifiers in column B of my spreadsheet which take either of the following four structures:

4056156
H27372
16-07192
Y99-07307

I need a VBA code which I can add into my worksheet data prep macro which will replace the "-" with "/".

The sticking point for me is that I only need to do this in the case of those identifiers which look like 16-07192 (two digits,-,5 digits).
For those identifiers which look like Y99-07307 (Y,two digits,-,5 digits) I need the "-" to remain as it is.

I'm fairly new to VBA programming and can't seem to get my head around this one or find a solution anywhere. I'd be really grateful for some help here. Thanks.

[JLGWhiz]

Please Login or Register  to view this content.

[Scepticseeker]

Fantastic that works great. Wouldn't have got there by myself, my VBA knowledge is as yet far too limited. Thank you so much!

[JLGWhiz]

Fantastic that works great. Wouldn't have got there by myself, my VBA knowledge is as yet far too limited. Thank you so much!

Yoo're welcome,
regards, JLG