Hi,
I have thousands of references and I need the first set of numbers from the reference but unfortunately some contain letters and some are of different lengths
REF-50789-LYD-12. (I need 50789 only)
REF-4089D-LYD-125 (I need 4089 only)
REF-23400-LYD-345 (I need 23400 only)
It will always lie between the first set of '-' but will be of varying lengths and i need the numbers only.
Is this possible? I'm.struggling to do this with just the MID function. Extremely.grateful for any help-thanks
Bookmarks