Can anyone help me with an excel formula to strip numbers from text as per tht examples below.I am only after the leading numbers not the end ones.So any numbers left of the MID text
1NBL1A to 1
286EBL1 to 286
6006SBL2 to 6006
Im new here so apologies in advance if I haver posted this incorrectly.
Thanks
1NBL1A to 1
286EBL1 to 286
6006SBL2 to 6006
Im new here so apologies in advance if I haver posted this incorrectly.
Thanks