Discussion Excel Mundur per Mestel Sectohva Naem ol ImportStars.txt

Fil oe daayn ayn ImportStars.txt blif aynd say looking jano per watuth essii tala robii zasti oe've visited enn a sectohva, simply misu luh raw datu enn gue lifra, aynd enn luh duwva lifra 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)))

Leu ser gons passun aynd wemo oe jano luh sectohva names aynd oe cayn luhn manipulate luh datu es oe dawl zulp.

Took mi a zem tivir per collate luhu vu feroo prebso shsay.