Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I'm using a Google Spreadsheet and trying to create a formula to remove a period and anything that comes before it in a cell.

For example:


I have used this in the past:

=(RIGHT(D2,FIND("whatever characters here",D2,1) - 1))

But the period "." is a wildcard. I have googled around for a few hours and still have nothing that works. Any insight would be awesome!

share|improve this question

migrated from Mar 23 '13 at 8:21

This question came from our site for computer enthusiasts and power users.

1 Answer 1

The following formula will split the result, using a "." as delimiter and show only the last column:


If there are more "." involved, then use this formula:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.