Hi - looking for some help.
Need a snippet of VBA to do the below.
1. Search the contents of Column A for "***FLOP*** [xxxxxx]" where the contents of [ ] will ALWAYS be different.
2. The snippet of code should then split up the contents within the brackets from [xxxxxx] to [xx xx xx].
Thanks
Need a snippet of VBA to do the below.
1. Search the contents of Column A for "***FLOP*** [xxxxxx]" where the contents of [ ] will ALWAYS be different.
2. The snippet of code should then split up the contents within the brackets from [xxxxxx] to [xx xx xx].
Thanks