| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find first period from the right
Find first period from the right
How do I do that? -- David P. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find first period from the right
What happens when you find this said period?
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find first period from the right
On Wed, 10 Dec 2008 18:44:01 -0800, David P.
wrote: Find first period from the right How do I do that? =FIND(CHAR(1),SUBSTITUTE(A1,".",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,".","")))) It will return an error if there are no periods in the string; otherwise it will return the position of the first period from the right (last period). --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Period Date? | Excel Discussion (Misc queries) | |||
| pay back period | Excel Worksheet Functions | |||
| Payback Period | Excel Discussion (Misc queries) | |||
| Period to Period percentage change? | Excel Discussion (Misc queries) | |||
| A 13 period exercise | Excel Worksheet Functions | |||
Linear Mode
