Hi, I have a raw text file with data in a single column
Search Success -> Found Tags [5] - Views: 1939 - Redundant string of text here
Data A1
Data A2
Data A3
Data A4
Data A5
Search Success -> Found Tags [5] - Views: 2219 - Redundant string of text here
Data B1
Data B2
Data B3
Data B4
Data B5
So pretty much, I need to keep the text in red, from the 1st ":" until the 3rd "-" every 6 rows and to be able to auto fill down
Thanks!
Try
=MID($A1,FIND(":",$A1)+2,4)
If all numbers are 4 digits
Not sure on your data layout for auto filling .
=MID(INDEX($A$1:$A$2,INT((ROWS($1:1)-1)/5)+1),FIND(":",INDEX($A$1:$A$2,INT((ROWS($1:1)-1)/5)+1))+2,4)
will fill numbers down a single column
Last edited by JohnTopley; 05-07-2018 at 05:48 AM.
some digits are larger than 4, they range for 3-6
Try this:
=LOOKUP(10^35,--MID(A1,FIND(":",A1)+2,{1,2,3,4,5,6,7,8,9}))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks