LinkBack URL
About LinkBacks
Hi Everyone
I am trying to write a formula to return the 1-2 digit numeral to the left and right of a - in an alpha numeric string
e.g., Group 12-18 returns 12 and 18
Thanks
Scott
Hi Everyone
I am trying to write a formula to return the 1-2 digit numeral to the left and right of a - in an alpha numeric string
e.g., Group 12-18 returns 12 and 18
Thanks
Scott
Easy for the example you have given us, but I'd like to bet the real problem is much more complex. Nonetheless, here we go for starters, assuming your text string is in A1:
Excel 2016 (Windows) 32 bit
=MID(A1,FIND("-",A1)-2,2) =RIGHT(A1,2)
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
You are great!! I was stumped on the MID formula and just couldn't work it out. I am writing a conditional formatting formula that turns red if the client's age is outside a given are range or becomes outside the age range. The age ranges change depending on the group assigned. Thank you.
So it WAS as simple as that - great!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks