If you get an ImportStars.txt file and are looking just to count up how many stars you've visited in a sector, simply paste the raw data in one column, and in the second column put:
=IF(ISNUMBER(SEARCH("-",TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",100)),200)))),IF(ISERR(FIND(" ",A1)),"",LEFT(A1,FIND(" ",A1)-1)),TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",100)),200)))
This will go through and give you just the sector names and you can then manipulate the data as you see fit.
Took me a little while to collate this so thought might share.
=IF(ISNUMBER(SEARCH("-",TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",100)),200)))),IF(ISERR(FIND(" ",A1)),"",LEFT(A1,FIND(" ",A1)-1)),TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",100)),200)))
This will go through and give you just the sector names and you can then manipulate the data as you see fit.
Took me a little while to collate this so thought might share.
Last edited: