Take the 2-minute tour ×
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:

idontwantthis.iwantthis

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
add comment

migrated from superuser.com Mar 23 '13 at 8:21

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

1 Answer

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

=INDEX(SPLIT(A1;"."),1,2)

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

=INDEX(SPLIT(A1;"."),1,LEN(A1)-LEN(SUBSTITUTE(A1,".",""))+1)
share|improve this answer
add comment

Your Answer

 
discard

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