asked on
Formula Revision
Hello, I have a formula that extracts data from a line. The formula is =MID(A1,FIND(" ",A1,FIND(" ",A1)+1)+4,2). The data format has changed a bit. See below
KDDD 091200Z 12010KT, current formual extracts 12
KDDD 091200Z 12010G18KT, need to extract 10
KDDD 091200Z COR 12010KT, need it to take in account and extra space and extract 10
KDDD 091200Z COR 12010G18KT, need to extract 10
KDDD 091200Z 12010KT, current formual extracts 12
KDDD 091200Z 12010G18KT, need to extract 10
KDDD 091200Z COR 12010KT, need it to take in account and extra space and extract 10
KDDD 091200Z COR 12010G18KT, need to extract 10
Microsoft Excel
Last Comment
barry houdini
ASKER CERTIFIED SOLUTION
THIS SOLUTION 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.
Sample file for above code
Get10.xlsx
Get10.xlsx
.......mmm, yes, my suggestion won't work, will it, even if 12 is constant because 12 can (and does) occur earlier in the string, so disregard my suggestion above.
Here's another possibility which identifies the text after the last space (a little like gbanik's suggestion)
=MID(TRIM(RIGHT(SUBSTITUTE
regards, barry
Here's another possibility which identifies the text after the last space (a little like gbanik's suggestion)
=MID(TRIM(RIGHT(SUBSTITUTE
regards, barry
ASKER
The 12 is not constant that value will change
Have u tried my suggestion?
ASKER
Hello in the formula =MID(A1,FIND("|",SUBSTITUT
SOLUTION
THIS SOLUTION 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.
=MID(A1,FIND("12",A1)+3,2)
regards, barry