View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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