mpouliot8168
New Member
- Joined
- Feb 10, 2012
- Messages
- 9
Hello,
This is my first post. I have a report that is exported from Sharepoint that gives me these item numbers that look like this
Item X #80; Item Y #126; Item Z #1
I would like to run a marco that would get rid of the # + the number that follows. The numbers can range from 1-1000. The result would look like this:
Item X; Item Y; Item Z
I would like to have this apply to the entire workbook not just the worksheet. Also this needs to run until all instances of the # + number removed. Then I would like to have a Msgbox appear that says that its has been completed. Thank you in advance for your replies!
This is my first post. I have a report that is exported from Sharepoint that gives me these item numbers that look like this
Item X #80; Item Y #126; Item Z #1
I would like to run a marco that would get rid of the # + the number that follows. The numbers can range from 1-1000. The result would look like this:
Item X; Item Y; Item Z
I would like to have this apply to the entire workbook not just the worksheet. Also this needs to run until all instances of the # + number removed. Then I would like to have a Msgbox appear that says that its has been completed. Thank you in advance for your replies!
Last edited:
