excel_learnerBrass ContributorNov 15, 2022Help with formula MID, TRIM I have a similar question to my previous one. if i have a list: WNI J950 Darlston WTT Washout WI J942 Rigby SEE Washby list goes on ... i just want to capture the 4 digits J950 or J942 in my ...Show More
OliverScheurichGold ContributorNov 15, 2022excel_learner =MID(A1,FIND(" ",A1)+1,4)You can try this formula.
