Jul 03 2021 08:48 PM
Hello. How can I return a number value that follows a text string in a linked cell. So, if a cell contains "CAA10/BLE15/UNTITLED 5" and I want the destination cell to always display the 2 digit number that immediately follows "BLE" (in this case 15), how could I do that? Here is an example of the possible source cell contents.
Thank you,
Joseph
Jul 03 2021 09:21 PM
SolutionJul 04 2021 08:43 AM
Thank you do much. This seems to work! Can I ask what the "+3" in the MID formula is for rather than just a "3"?
Jul 04 2021 08:43 AM
Jul 04 2021 01:02 PM
@JosephA1915 The FIND function finds the first character of the string "BLE". Then you need to add three characters (B,L and E) to arrive at the first position that could be a number,
Jul 04 2021 01:16 PM
Jul 03 2021 09:21 PM
Solution