Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extracting text from Alphanumeric Cell
Is there VBA coding I can use for the following:
I have the following data Clinical Team Manager 1 Clinical Team Manager 2 Clinical Team Manager 3 Project Manager 1 Project Manager 2 Project Director 1 Project Director 2 Project Associate 1 Project Associate 2 Project Associate 3 Project Associate 1 - Prod Reg Project Associate 2 - Prod Reg Project Associate 3 - Prod Reg what I want the coding to do is to replace the data with only the job title so the text before the number. Does that make sense? Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting numbers from alphanumeric string | Excel Discussion (Misc queries) | |||
Extracting numbers from alphanumeric data | Excel Discussion (Misc queries) | |||
Extracting numbers from alphanumeric strings | Excel Worksheet Functions | |||
extracting numbers from alphanumeric cells | Excel Worksheet Functions | |||
extracting numbers from alphanumeric strings | Excel Programming |