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.
|