New answers tagged substring
0 votes
Excel - Extract 2 characters after specific text in string
The following formula with REGEX gives the result (see below) =REGEXEXTRACT(A1,"(?<=Power:).{2}") INPUT OUTPUT Every 2 Hours Power:123 Sail:0 SWC:3 BCR:0 CJC:0 CU:0 CSC:0 12 Every 2 ...
- 7,661
Top 50 recent answers are included