I'm using a Google Sheets 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!