| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Replace without macros | Excel Worksheet Functions | |||
| Conditional FIND and REPLACE | Excel Worksheet Functions | |||
| Create a conditional formula to replace | Excel Worksheet Functions | |||
| Is it possible to do a Find/Replace on Conditional Formats? | Excel Worksheet Functions | |||
| Replace conditional formatting to use 4 conditions | Excel Programming | |||
![Mikey B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
