| Home |
| Search |
| Today's Posts |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Turning green
Many thanks David. Very helpful.
"David Biddulph" wrote: You may get somewhere with functions like TRIM and CLEAN, but if your spurious extra character is consistently at one end or the other of the string you might use =LEFT(A1,LEN(A1)-1) or =RIGHT(A1,LEN(A1)-1) as applicable. -- David Biddulph "bollard" wrote in message ... Hi David That's very interesting! When I run the LEN formula, every No shows up as 3 and every Yes as 4. What can I do to overcome this? "David Biddulph" wrote: Make sure you haven't got spare spaces or other non-printing characters in M2. Does =LEN(M2) give you the answer 3? Also double check that you've got "Formula Is" in your CF, not "Cell value is". -- David Biddulph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| green marker in cell ? | Excel Discussion (Misc queries) | |||
| Help, need to make field go red or green | Excel Worksheet Functions | |||
| little green triangles - XL 2003 | Excel Discussion (Misc queries) | |||
| Turning #N/A to a zero...?? | Excel Discussion (Misc queries) | |||
| how 'come green isn't green? | Excel Discussion (Misc queries) | |||
Threaded Mode
