tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Column C holds a list of names thats not very clean,
I was hoping there was a way to remove everything but the first name from each cell?
so I need a macro then when run is quite cleaver and leaves me with just first names,
I've tried doing it with a list of things to remove but quite honestly its such a mess its hard as the list get longer and longer so how about this?
a macro to run in column C that remove everything but the first name by looking at the cell finding the first string of letters longer than 1 that has a space after it or is the only word and removes everything else?
I'm thinking I cant be the first person to have this problem so hopfully someone know a great way to do it?
thanks
Tony
Column C holds a list of names thats not very clean,
I was hoping there was a way to remove everything but the first name from each cell?
so I need a macro then when run is quite cleaver and leaves me with just first names,
I've tried doing it with a list of things to remove but quite honestly its such a mess its hard as the list get longer and longer so how about this?
a macro to run in column C that remove everything but the first name by looking at the cell finding the first string of letters longer than 1 that has a space after it or is the only word and removes everything else?
I'm thinking I cant be the first person to have this problem so hopfully someone know a great way to do it?
thanks
Tony