View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mikey B[_2_] Mikey B[_2_] is offline
external usenet poster
 
Posts: 9
Default Conditional replace

I am looking to search one column for "V" in a string.

When there is a letter preceding the "V" I need to add "-" between the
letter and the "V".
When there is a number preceding the "V" then I need it to leave it like it
is.

Results need to look like this.

old new
1MSV01 1MS-V01
1MS4V01 1MS4V01

Anyone have any ideas how I could do this quickly. I have several sheets
with several thousand records each.