I need a way to loop through cells in a specific column (eg. A) and check if they start with 5 or more numbers. If so I need to delete everything after the numbers end.
So for example it will start like this
4165460 ABC 546445 SDF 4654843354 FHD ABD 132 1254 AHD
And need it to end up like this
4165460 546445 4654843354 ABD 132 1254 AHD
Bookmarks