Insert hyphen/dash in the middle of numbers

Hello

I am aware of this question being asked before but I have not been able to solve it with the past responses as I am too big of a rookie on excel.

I several rows of information that I would like to insert a hyphen within after the fifth letter/digit. Every row starts with 1 letter and is then followed by 10 digits and looks like "M3858730131". The information is currently located in B2-B964.

I would like to permanently insert a hyphen after the fifth digit and not just format it so it looks good in excel.

Is this solvable only with VBA or some other method? If VBA is the only possibility I could use some guidance there on how to use it as well

Thanks in advance!

Best regards,
noxious

Thank you, but how do I make use of this function? Where do i put it to make it affect all rows?

Cheers

VBA?

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Or?

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Or?

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

Or?

Please Login or Register  to view this content.

Works flawless. Thank you very much!

You're welcome. Glad to help out and thanks for the feedback.

How can I delete a hyphen using this sub test VBA