Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Searching in a Function
Let's say I have one column with data like this: C012
But all I want to do is return all cells in that column that start with "C" (there are many cells that start with other letters). I want to use an IF formula that looks at only the first letter in these cells. Maybe it would look like this: =IF(A2="C###", but that doesn't work. Is there a placeholder and format so it only looks at the first letter? Thanks, Matt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Searching in a Function
=IF(left(A2,1)="C",
"malvis" wrote: Let's say I have one column with data like this: C012 But all I want to do is return all cells in that column that start with "C" (there are many cells that start with other letters). I want to use an IF formula that looks at only the first letter in these cells. Maybe it would look like this: =IF(A2="C###", but that doesn't work. Is there a placeholder and format so it only looks at the first letter? Thanks, Matt |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Searching in a Function
Hi,
Try This =IF(LEFT(A2,1)="C","C","") TGV "Sean Timmons" wrote: =IF(left(A2,1)="C", "malvis" wrote: Let's say I have one column with data like this: C012 But all I want to do is return all cells in that column that start with "C" (there are many cells that start with other letters). I want to use an IF formula that looks at only the first letter in these cells. Maybe it would look like this: =IF(A2="C###", but that doesn't work. Is there a placeholder and format so it only looks at the first letter? Thanks, Matt |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Searching in a Function
Hi,
Try This =IF(LEFT(A2,1)="C","C","") TGV "malvis" wrote: Let's say I have one column with data like this: C012 But all I want to do is return all cells in that column that start with "C" (there are many cells that start with other letters). I want to use an IF formula that looks at only the first letter in these cells. Maybe it would look like this: =IF(A2="C###", but that doesn't work. Is there a placeholder and format so it only looks at the first letter? Thanks, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
searching for a function | Excel Worksheet Functions | |||
searching for function | Excel Discussion (Misc queries) | |||
Searching for text | Excel Discussion (Misc queries) | |||
searching for specific text | Excel Discussion (Misc queries) | |||
help searching text | Excel Discussion (Misc queries) |