Thread
:
How to Insert Dashes
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
How to Insert Dashes
Have a look in HELP index for MID
--
Don Guillett
SalesAid Software
"childofthe1980s" wrote in
message ...
Hello:
In various cells, I have such data as "1000001p" How can I have Excel
automatically change it to "1000-001P" or even "1000-001-P"?
You see, I need dashes inserted and I need the last alpha character to be
capitalized.
Thanks!
childofthe1980s
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]