| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if alpha character
The following cells:
00000000000A 00000000000B 00000000005 if right(a1)=alpha character then everything left of the character, else the entire field. How do I code this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if alpha character
=IF(ISNUMBER(--RIGHT(A1,1)),A1,LEFT(A1,LEN(A1)-1))
-- Gary''s Student - gsnu200820 "samuel" wrote: The following cells: 00000000000A 00000000000B 00000000005 if right(a1)=alpha character then everything left of the character, else the entire field. How do I code this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if alpha character
=IF(CODE(RIGHT(A1))=65,LEFT(A1,LEN(A1)-1),A1)
-- David Biddulph "samuel" wrote in message ... The following cells: 00000000000A 00000000000B 00000000005 if right(a1)=alpha character then everything left of the character, else the entire field. How do I code this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if alpha character
One way using a formula in another cell:
=IF(ISNUMBER(-RIGHT(A1,1)),A1,LEFT(A1,LEN(A1)-1)) or to return a number (not text): =--(IF(ISNUMBER(-RIGHT(A1,1)),A1,LEFT(A1,LEN(A1)-1))) Not exactly what you asked, but probably sufficient???? samuel wrote: The following cells: 00000000000A 00000000000B 00000000005 if right(a1)=alpha character then everything left of the character, else the entire field. How do I code this? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if alpha character
Another one...
Doesn't account for empty cells: =LEFT(A1,LEN(A1)-ISERR(-RIGHT(A1))) -- Biff Microsoft Excel MVP "samuel" wrote in message ... The following cells: 00000000000A 00000000000B 00000000005 if right(a1)=alpha character then everything left of the character, else the entire field. How do I code this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
| PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
| PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
| Parsing a alpha character out of a cell | Excel Worksheet Functions | |||
| Numerical grade to Alpha character | Excel Discussion (Misc queries) | |||
Linear Mode
