The format is suppose to be that of line 3 but we get answers such as 4, 5, 6, 7 how can i correctly get the results ?
| Book9.xlsx | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | Resolution | |||
| 2 | user reports that BEx is working now. No need for refresh | No Device In Resolution | ||
| 3 | New Device : D261488 Old Device: D224917 | Old Device: D224917 | ||
| 4 | 8-10-22 - INC000003879569 - Service Request Dominguez Hills S/C, DM Hills, CA Old Device: D216495 New Device: D262146 Delivered, Installed and configured new device replacing old device Installed all required applications Copied and restored all clients data Jeff Lindberg Service Request Complete Resolving ticket | Old Device: D216495 | ||
| 5 | replaced old d229262 with D262555 new | No Device In Resolution | ||
| 6 | Guadalupe J. Aviles 8/1/2022 INC000003924470 Refreshed D229755 (7480) with D259495 on 7/22/2022 due to system instability, slowness caused by unrecoverable OS corruption. New 5420 laptop profiled and tested onsite by EU. IBC | No Device In Resolution | ||
| 7 | replaced old: D231170 with D260176 new | No Device In Resolution | ||
Sheet1 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2:B7 | B2 | =IFERROR(TEXTJOIN(CHAR(10),,FILTERXML("<k><m>"&SUBSTITUTE(A2,CHAR(10),"</m><m>")&"</m></k>","//m[starts-with(.,'Old Device')]")),"No Device In Resolution") |
