I'm trying to figure out a formula that will capture only specific parts of a cells string...
I need a cell in Q to capture specific parts of the adjacent cell to it in column R:
![Capture487.JPG Capture487.JPG](https://www.mrexcel.com/board/data/attachments/113/113637-27ab4970afed2e03131ff694534b241c.jpg)
![Capture488.JPG Capture488.JPG](https://www.mrexcel.com/board/data/attachments/113/113638-855917388e81f565ee9ab99170458e33.jpg)
I need to capture only the following strings that may (or may not) reside as part of cell R: "CSR21U", "CSR22V", "CSR23W", "CSR24X" or "CSR25Y"
so in the example pics I have shown above, in this particular cell (R18), both CSR23W and CSR24X are present:
![Capture490.JPG Capture490.JPG](https://www.mrexcel.com/board/data/attachments/113/113639-232ff3eb9403a97eb21a627fae3ff7fb.jpg)
meaning CSR23W and CSR24X would be copied from the target cell and will be displayed in the formula row in cell Q18:
![Capture491.JPG Capture491.JPG](https://www.mrexcel.com/board/data/attachments/113/113640-42d9a5c651604df3d20d74b33c9b5e92.jpg)
Any help is surely appreciated!!
I need a cell in Q to capture specific parts of the adjacent cell to it in column R:
![Capture487.JPG Capture487.JPG](https://www.mrexcel.com/board/data/attachments/113/113637-27ab4970afed2e03131ff694534b241c.jpg)
![Capture488.JPG Capture488.JPG](https://www.mrexcel.com/board/data/attachments/113/113638-855917388e81f565ee9ab99170458e33.jpg)
I need to capture only the following strings that may (or may not) reside as part of cell R: "CSR21U", "CSR22V", "CSR23W", "CSR24X" or "CSR25Y"
so in the example pics I have shown above, in this particular cell (R18), both CSR23W and CSR24X are present:
![Capture490.JPG Capture490.JPG](https://www.mrexcel.com/board/data/attachments/113/113639-232ff3eb9403a97eb21a627fae3ff7fb.jpg)
meaning CSR23W and CSR24X would be copied from the target cell and will be displayed in the formula row in cell Q18:
![Capture491.JPG Capture491.JPG](https://www.mrexcel.com/board/data/attachments/113/113640-42d9a5c651604df3d20d74b33c9b5e92.jpg)
Any help is surely appreciated!!