Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I - Strip last letter from field
I want to strip the last character from a cell, but only if it is a number.
0040:P0200C would return C 040:PT1C would return C 0040:P202 wouldn't return anything or null |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I - Strip last letter from field
Try the below formula with the data in cell A1
=IF(ISNUMBER(RIGHT(A1,1)+0),"",RIGHT(A1,1)) If this post helps click Yes --------------- Jacob Skaria "Benjamin" wrote: I want to strip the last character from a cell, but only if it is a number. 0040:P0200C would return C 040:PT1C would return C 0040:P202 wouldn't return anything or null |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I - Strip last letter from field
.... or you could simplify to =IF(ISNUMBER(RIGHT(A1)+0),"",RIGHT(A1))
-- David Biddulph "Jacob Skaria" wrote in message ... Try the below formula with the data in cell A1 =IF(ISNUMBER(RIGHT(A1,1)+0),"",RIGHT(A1,1)) If this post helps click Yes --------------- Jacob Skaria "Benjamin" wrote: I want to strip the last character from a cell, but only if it is a number. 0040:P0200C would return C 040:PT1C would return C 0040:P202 wouldn't return anything or null |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you strip the time of day out of a date field | Excel Discussion (Misc queries) | |||
Strip Out Time | New Users to Excel | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
TAB STRIP | Excel Discussion (Misc queries) | |||
tab strip | New Users to Excel |