Hi there.
Ive been successful until now googling what I need, but am now stuck with this issue/query
I have cells containing order number data which is a mix of alpha numeric alpha and numeric.
See example.
EM243811
EM231390P01
EM23263IT
I need to extract or end up with the following:
243811
231390
23263
The best I can get is
243811
23139001 - the 01 on the end I dont need and I cant get it to be excluded.
23263
Any help appreciated.
Thanks
Bookmarks