In a cell there will be large amount of data. I am looking for a macro that can identify a specific text pattern and extract and paste in a different cell.
Pattern will be consistent
characters in the pattern will not be consistent
There may be space before and after the pattern begins and ends
In some cases, there may not be space before or after
Pattern will be like xxxxxx-xxxxxx-xxxxxx-xxxxxx
It will be a combination of numerics and texts.
Paste this code into a new module:
Then you can use, for example, the following formula to extract the pattern:
Please Login or Register to view this content.
WBDPlease Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
Assuming Data in col.A, output in Col.B
Please Login or Register to view this content.
Arrgh! My eyes are too old; I didn't see there were 6 x's in each group. You *could* therefore use this:
Note that this pattern *insists* that there isn't an extra matching character at the beginning/end of the matched string.Please Login or Register to view this content.
WBD
Thank you so much Dixon. The macro did work. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks