Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
How do I find cells that contain specific characters and pull them out of a
long line of cells? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
Hi!
What does: "pull them out of a long line of cells" mean? Can you provide some examples? Biff "mshornet" wrote in message ... How do I find cells that contain specific characters and pull them out of a long line of cells? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
Try using the funtionality found from the main menu Edit Find.
"mshornet" wrote: How do I find cells that contain specific characters and pull them out of a long line of cells? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
Thanks for your reply. What I would like to do is search a column of cells
and contain text. Some of the cells contain the letters "vo". Others do not. I want to select those cells that contain "vo" and copy them to another column. "Biff" wrote: Hi! What does: "pull them out of a long line of cells" mean? Can you provide some examples? Biff "mshornet" wrote in message ... How do I find cells that contain specific characters and pull them out of a long line of cells? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
Thanks. I should explain my problem better. I have a long column of cells
that contain text. Some of these cells have the characters "VO" in them. I want to find those cells and make a new column of cells with only those cells that contained "VO" in them. "Roland" wrote: Try using the funtionality found from the main menu Edit Find. "mshornet" wrote: How do I find cells that contain specific characters and pull them out of a long line of cells? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
Hi!
The easiest way: Assume the data is in the range A2:A100, A1 is the column header. Select cell A1 Goto DataFilterAutoFilter Click the arrow that appears in cell A1 Select CUSTOM From the drop down that says EQUALS, select CONTAINS In the box to the right enter: vo Click OK. Do your copy/paste Then turn off the filter: Data FilterAutoFilter (selecting AutoFilter toggles it on or off) Biff "mshornet" wrote in message ... Thanks for your reply. What I would like to do is search a column of cells and contain text. Some of the cells contain the letters "vo". Others do not. I want to select those cells that contain "vo" and copy them to another column. "Biff" wrote: Hi! What does: "pull them out of a long line of cells" mean? Can you provide some examples? Biff "mshornet" wrote in message ... How do I find cells that contain specific characters and pull them out of a long line of cells? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
DataFilterAutofilter
Filter on VO then copy those cells to another column. Gord Dibben Excel MVP On Sat, 19 Nov 2005 19:09:02 -0800, "mshornet" wrote: Thanks. I should explain my problem better. I have a long column of cells that contain text. Some of these cells have the characters "VO" in them. I want to find those cells and make a new column of cells with only those cells that contained "VO" in them. "Roland" wrote: Try using the funtionality found from the main menu Edit Find. "mshornet" wrote: How do I find cells that contain specific characters and pull them out of a long line of cells? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
Thank you. Sorry for my slow response. Thanks again.
"Biff" wrote: Hi! The easiest way: Assume the data is in the range A2:A100, A1 is the column header. Select cell A1 Goto DataFilterAutoFilter Click the arrow that appears in cell A1 Select CUSTOM From the drop down that says EQUALS, select CONTAINS In the box to the right enter: vo Click OK. Do your copy/paste Then turn off the filter: Data FilterAutoFilter (selecting AutoFilter toggles it on or off) Biff "mshornet" wrote in message ... Thanks for your reply. What I would like to do is search a column of cells and contain text. Some of the cells contain the letters "vo". Others do not. I want to select those cells that contain "vo" and copy them to another column. "Biff" wrote: Hi! What does: "pull them out of a long line of cells" mean? Can you provide some examples? Biff "mshornet" wrote in message ... How do I find cells that contain specific characters and pull them out of a long line of cells? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cells that contain specific characters
Thanks. Sorry for my slow reply. Thanks again.
"Gord Dibben" wrote: DataFilterAutofilter Filter on VO then copy those cells to another column. Gord Dibben Excel MVP On Sat, 19 Nov 2005 19:09:02 -0800, "mshornet" wrote: Thanks. I should explain my problem better. I have a long column of cells that contain text. Some of these cells have the characters "VO" in them. I want to find those cells and make a new column of cells with only those cells that contained "VO" in them. "Roland" wrote: Try using the funtionality found from the main menu Edit Find. "mshornet" wrote: How do I find cells that contain specific characters and pull them out of a long line of cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
Is there away to have specific cells unlock based on the entry of information in another? | New Users to Excel | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) |