Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
match a word in a cell and copy anoher cell in the same row
Hi - sorry another question from me today!
Is there a formula or way to achieve the following please I want to search through a column (say column B) containing both words and numbers to see if any cell in that column contains a specific word if it does I want the corresponding cell in column A (same row) to copy into a thirds column. Hope this makes sense -- Thanks Lise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
match a word in a cell and copy anoher cell in the same row
The below formula would return value of ColA if the text in ColB contains the
word BK. Copy the formula to C1 and copy down as required Col A Col B Col C John BK1234 =IF(ISERROR(SEARCH("BK",B1)),"",A1) Mary BK4563 Joe BK5356 Maria AB1234 If this post helps click Yes --------------- Jacob Skaria "Lise" wrote: Hi - sorry another question from me today! Is there a formula or way to achieve the following please I want to search through a column (say column B) containing both words and numbers to see if any cell in that column contains a specific word if it does I want the corresponding cell in column A (same row) to copy into a thirds column. Hope this makes sense -- Thanks Lise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
Copy Word cell containing Shift/Enter to Excel.Keep it as 1 cell | Excel Discussion (Misc queries) | |||
word match in string text in cell, color format cell | Excel Discussion (Misc queries) | |||
Copy Cell to Word ? | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) |