I have a column filled with websitenames and ip address. i need only entries with ip addresses from it and all entries containing alphabets should be wiped out
eg
1.yahoo.com
cnn.com
299.212.390.21
gsddksjdk.com
1.1.2.2
The output should come as
299.212.390.21
1.1.2.2
Hi Shadowknight,
Looking for like this ?
=IsNumber(Trim(A1)*1)
try this formula in cell b1 and drag down where is the data in column a.
If answer helped you say Thanks by Add Reputation
doesnt work. i only see the word false in the entire b column.
Please explain more clearly . do you mean the B column has to be dragged or the a column
Last edited by shadowknight; 02-07-2015 at 10:14 AM.
With the data starting in A1, enter this in B1 and fill down. All strings with alpha characters will be marked as TRUE. Select both column A and B and sort to get all the TRUE values together and then delete them.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hallo,
that is the formula which gives "TRUE" if there is only characters available in cell and Return with "False" when there is only numeric value.
Hallo,
What formula talking about? About newdoverman's formula?
That is, the formula returns TRUE or FALSE. Then filter by TRUE and then delete those rows. You get what OP wants.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks