Can someone help me with this. I've been away from VBA for over 2 year
and my mind is rusty.

I have a range selected that will be letters, then numbers as one word
I want to add a hypthen in between the letters and numbers. How can i d
this VBA wise?

Ex.

abc123 - abc-123
ghj1234 - ghj-1234
wa76 - wa-76

Thanks alot guys,
mb

--
mbk14
-----------------------------------------------------------------------
mbk141's Profile: http://www.excelforum.com/member.php...fo&userid=1575
View this thread: http://www.excelforum.com/showthread.php?threadid=27267