Hi,
Let's say we have a text string in the excel cell: 12.123.12.1
Is there any way to get the latest dot's position using excel's functions?
Thanks in advance!
Hi,
Let's say we have a text string in the excel cell: 12.123.12.1
Is there any way to get the latest dot's position using excel's functions?
Thanks in advance!
Yes:
Please Login or Register to view this content.
I assume these are IP address and as they split into 4 section with 3 dots you can use the following
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks