Find the last dot in an entry and return the characters after it

**Hitch75** · 07-17-2015, 06:28 AM

I need a formula which will find the LAST dot in an entry like this one:
76523.867.6217.12.242
and return only the numbers after the last dot, in this case 242.

Can someone help pls?

**Ace_XL** · 07-17-2015, 06:41 AM

Try

=TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",255)),255))

**Hitch75** · 07-17-2015, 07:03 AM

That's it

Thanx!!

Find the last dot in an entry and return the characters after it

LinkBack

Thread Tools

Rate This Thread

Display

Find the last dot in an entry and return the characters after it

Re: Find the last dot in an entry and return the characters after it

Re: Find the last dot in an entry and return the characters after it

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find last entry in row and return column header name

[SOLVED] Find last entry in row and return column header

Find and return mutliple lines of data based on single entry

return 4 characters usign find

find entry in corresponding sheet and return related value

return previous entry if INDEX returns a blank entry (in a broken series of columns)

[SOLVED] [SOLVED] Find/Replace carriage return & line feed characters in Excel.

Bookmarks

Bookmarks

Posting Permissions

Find the last dot in an entry and return the characters after it

Re: Find the last dot in an entry and return the characters after it

Re: Find the last dot in an entry and return the characters after it

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find last entry in row and return column header name

[SOLVED] Find last entry in row and return column header

[SOLVED] [SOLVED] Find/Replace carriage return &amp; line feed characters in Excel.

Bookmarks

Bookmarks

Posting Permissions

[SOLVED] [SOLVED] Find/Replace carriage return & line feed characters in Excel.