StevenPMoffat
asked on
Extract SubString from Middle of string
I need a simple function that will extract the substring that starts at position 5 and includes up to the first "-".
For Instance:
With
ABC-System1-012345960 I Get System1
ABC-A-34509 I get A.
For Instance:
With
ABC-System1-012345960 I Get System1
ABC-A-34509 I get A.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If the location of the first dash will change, it needs to get a tiny bit more complex:
Basically replace each 5 with a find:
=MID(A1, FIND("-",A1)+1, FIND("-", A1 & "-",FIND("-",A1)+1)-FIND("
Basically replace each 5 with a find:
=MID(A1, FIND("-",A1)+1, FIND("-", A1 & "-",FIND("-",A1)+1)-FIND("
here you go!
=MID(A1,5,FIND("-",A1,5)-5
---Assuming A1 is your value
=MID(A1,5,FIND("-",A1,5)-5
---Assuming A1 is your value
ASKER
Thank You
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
=Mid(A1, 5, Find("-", A1, 6)-5)