HelvetiiOnExcel
New Member
- Joined
- Aug 23, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- MacOS
Hi Everyone,
Long time lurker and first time poster. I am looking for advice on creating a macro that will apply the find and replace function to cells in specific rows of a selected column. I.e. user will select column 'E', from there cells in rows 5,9,10,23,45, would have all text after a '-' in their formula removed (-* with find and replace) and then cells in row 7, 16, 34, would have all text before a '+' removed (*+) with find and replace. Would appreciate any and all support. I've gotten the part of identifying the column value and such, but applying that to specific cells has been tough.
Thanks.
Long time lurker and first time poster. I am looking for advice on creating a macro that will apply the find and replace function to cells in specific rows of a selected column. I.e. user will select column 'E', from there cells in rows 5,9,10,23,45, would have all text after a '-' in their formula removed (-* with find and replace) and then cells in row 7, 16, 34, would have all text before a '+' removed (*+) with find and replace. Would appreciate any and all support. I've gotten the part of identifying the column value and such, but applying that to specific cells has been tough.
Thanks.