| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find text string and move contents to another cell
How can I find a specific string in a worksheet and move it to another column?
In Excel 2003, Sheet Range A1:N250 Column "N" of a worksheet "spares" contains text "PRP Pxxxxx" or "Prod xxxxx" where x is a number. I want to cut and paste anything containing "PRP" to column Q, and "Prod" to column R, leaving the cell in column N blank. Thanks in advance for any advice |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Need to find particular string within cell text, if found a value is copied | Excel Programming | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| VBA - Move cell contents if bold text | Excel Programming | |||
| Find text and move it to other cell | Excel Programming | |||
Threaded Mode
