Hi All,
I have a excel file with each cell having multiple rows of data in them.
IP address starting "10.x.x.x" is one of values in the several rows of data in each cell.
I need a formula or code, which looks for this IP address and generates it in the Output file.
Kindly refer the sample file attached for more details.Sample Excel File.xlsx
Enter formula in B2 and pull it down
=IF(--LEFT(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",125)),125)),2)=10,TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",125)),125)),"NA")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Would this work?
=IFERROR(MID(A2,FIND("10.",A2),(IFERROR(FIND(" ",A2,FIND("10.",A2)),LEN(A2)+1)-FIND("10.",A2))),"NA")
Maybe even this will work for you.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks