View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Boogie Boogie is offline
external usenet poster
 
Posts: 8
Default Find Capital Letter

Example: In A1 BoogieMByron. How can make it as in A2 Boogie M Byron. There's
hundreds of names whereby Firstname,MI,LastName are all in one word. I want
to cleate a space before and after Middle initial. Thanks for your help.