Find first period from the right

  • Thread starter Thread starter David P.
  • Start date Start date
Find first period from the right

How do I do that?
Click to expand...

=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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

locate a column, sum specific columns to the right of that column 3
Power Pivot Variance Column 0
Double space - period shortcut? 2
Period Calendar 4
Creating an update query that uses multiple parameters 2
Find Period Date? 5
Delta Variances by Period 8
Custom 4 week periods 1

Back
Top