Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
How would I do this?:
=IF(A comma is found in A1),... Thanks. -- David P. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
=IF(A comma is found in A1),...
=IF(ISNUMBER(SEARCH(",",A1)), ... -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
Another one:
=IF(COUNT(FIND(",",A1)),..... Note that this doesn't work on numbers using a number comma format (10,000) -- Biff Microsoft Excel MVP "David P." wrote in message ... How would I do this?: =IF(A comma is found in A1),... Thanks. -- David P. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
Assumes that A1 contains text:
=IF(ISERROR(FIND(",",A1)),"comma not found","comma found") Joerg "David P." wrote in message ... How would I do this?: =IF(A comma is found in A1),... Thanks. -- David P. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
Here is another approach...
=IF(LEN(A1)=LEN(SUBSTITUTE(A1,",","")),"No comma","There's a comma") -- Rick (MVP - Excel) "David P." wrote in message ... How would I do this?: =IF(A comma is found in A1),... Thanks. -- David P. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
One mo
=if(countif(a1,"*,*")0,"found","not found") David P. wrote: How would I do this?: =IF(A comma is found in A1),... Thanks. -- David P. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
I like this one best... one function call. Let's remove the comparison just
to shorten it up a bit... =IF(COUNTIF(A1,"*,*"),"found","not found") -- Rick (MVP - Excel) "Dave Peterson" wrote in message ... One mo =if(countif(a1,"*,*")0,"found","not found") David P. wrote: How would I do this?: =IF(A comma is found in A1),... Thanks. -- David P. -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
I find using the comparison self-documenting.
Rick Rothstein wrote: I like this one best... one function call. Let's remove the comparison just to shorten it up a bit... =IF(COUNTIF(A1,"*,*"),"found","not found") -- Rick (MVP - Excel) "Dave Peterson" wrote in message ... One mo =if(countif(a1,"*,*")0,"found","not found") David P. wrote: How would I do this?: =IF(A comma is found in A1),... Thanks. -- David P. -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
That is true enough (but I would guess doing introduces an extra, albeit
very quick, calculation to the formula). -- Rick (MVP - Excel) "Dave Peterson" wrote in message ... I find using the comparison self-documenting. Rick Rothstein wrote: I like this one best... one function call. Let's remove the comparison just to shorten it up a bit... =IF(COUNTIF(A1,"*,*"),"found","not found") -- Rick (MVP - Excel) "Dave Peterson" wrote in message ... One mo =if(countif(a1,"*,*")0,"found","not found") David P. wrote: How would I do this?: =IF(A comma is found in A1),... Thanks. -- David P. -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a comma is found
I think it makes the formula easier to understand -- especially for the posters
who are asking this type of question. And it may make it easier to use the function in different formulas. Rick Rothstein wrote: That is true enough (but I would guess doing introduces an extra, albeit very quick, calculation to the formula). -- Rick (MVP - Excel) "Dave Peterson" wrote in message ... I find using the comparison self-documenting. Rick Rothstein wrote: I like this one best... one function call. Let's remove the comparison just to shorten it up a bit... =IF(COUNTIF(A1,"*,*"),"found","not found") -- Rick (MVP - Excel) "Dave Peterson" wrote in message ... One mo =if(countif(a1,"*,*")0,"found","not found") David P. wrote: How would I do this?: =IF(A comma is found in A1),... Thanks. -- David P. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If no comma found | Excel Discussion (Misc queries) | |||
Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
IF NOT FOUND | Excel Worksheet Functions | |||
Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) |