Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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

You just need to use the backslash to escape the period character, so you have one of two options:

for regexextract to capture everything after the period, thus ignoring everything before it:

=REGEXEXTRACT(A1,"\.(.*)")

or regexreplace to replace everything including and before the period:

=REGEXREPLACE(A1,"(.*\.)","")
share|improve this 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

Your Answer

 
discard

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