Remove last number from IP Address Excel

[sismeya]

Hi,

I wonder if someone could help?

I need to remove the last number from a list of IP Addresses in an excel spreadsheet e.g:

10.1.11.12
10.19.11.23
10.22.23.202
10.2.3.7

to

10.1.11
10.19.11
10.22.23
10.2.3

I have tried using =RIGHT(A1,FIND(".",A1)-1) but this just leaves me with the number I dont need, any help would be great

Cheers

Andy

[zbor]

Maybe this:

=SUBSTITUTE(LEFT(SUBSTITUTE(A1, ".", REPT(" ", 100), 3), 100), " ", "")

[sismeya]

Thank you so much works perfectly you just saved me hours of work !!

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save