SH Harbour
New Member
- Joined
- Aug 22, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi, I have a worksheet which I need a Macro to search through column E2:E and find the info between #~ and 954#N and then put the relevant info in the corresponding cell F, an example of the info is as follows:
I would like it to appear as follows:
I can produce a formula which produces the result as follows:
= Mid(E2, Search("#~~", E2) + 1, Search("#954#N", E2, Search("#~", E2) + 1) - Search("#~~", E2) - 1)
However would rather have a Macro that could perform the operation, any assistance would be greatly appreciated?
Thanks
I would like it to appear as follows:
I can produce a formula which produces the result as follows:
= Mid(E2, Search("#~~", E2) + 1, Search("#954#N", E2, Search("#~", E2) + 1) - Search("#~~", E2) - 1)
However would rather have a Macro that could perform the operation, any assistance would be greatly appreciated?
Thanks