I need the formula to extract these specific items moved to their own column. I can't figure out the formula to do so.
Thanks in Advance
I need the formula to extract these specific items moved to their own column. I can't figure out the formula to do so.
Thanks in Advance
Hi Christianne: Welcome to the forum.
An excel file containing a brief example of your sanitized data which shows your desired result would be a better file to attach.
Pete
Last edited by PeteABC123; 11-23-2021 at 01:02 PM.
If you mean you want to physically move the data to another location, so that it no longer exists in it's original location (rather than just copy the data elsewhere and have the original data stay where it is), you cannot do that with a formula, you will need VBA.
Last edited by FDibbins; 11-24-2021 at 12:19 AM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks