tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Hope someone can help,
What i need is a macro that when run does the following,
Cleans up the data in Sheet "DATA" column B buy doing these things
first, remove all trailing zeros (i.e. trim the cells)
then make all the data "proper" so "MIKE smith" becomes "Mike Smith" etc.
then and this is the hardest part,
in sheets Control Column C (Excluding row1 as its the header) I have a list of words, In D i have a list of replacement words or it might be blank,
I want the macro to go down the list in Control Column C, one at a time and find the word in Sheet "DATA" column B and replace with what's in column D if its possible it would be perfect if in column E i could put "Whole" for the find and replace to just replace if it the whole cell and blank does any.
I hope that makes sense and someone can help me
Thanks
Tony
Hope someone can help,
What i need is a macro that when run does the following,
Cleans up the data in Sheet "DATA" column B buy doing these things
first, remove all trailing zeros (i.e. trim the cells)
then make all the data "proper" so "MIKE smith" becomes "Mike Smith" etc.
then and this is the hardest part,
in sheets Control Column C (Excluding row1 as its the header) I have a list of words, In D i have a list of replacement words or it might be blank,
I want the macro to go down the list in Control Column C, one at a time and find the word in Sheet "DATA" column B and replace with what's in column D if its possible it would be perfect if in column E i could put "Whole" for the find and replace to just replace if it the whole cell and blank does any.
I hope that makes sense and someone can help me
Thanks
Tony