Adding Hyphen in Between of Strings Using Macros

[madhuchelliah]

Hello Mates, i want to insert a hyphen in between of strings in the A column. My string format is AA111AA111 BB222BB222,....... A space is separating the strings. Number of strings are dynamic. Hyphen should be inserted exactly middle of the string that is after 5th character. So the result should be like this AA111-AA111 BB222-BB222 displayed in B column. Thank you.

 

[Peter_SSs]

Thank you both of you

You're very welcome.