question - sort the data

Rains · Oct 16, 2018

hello,,, i need help sorted some data i scraped

2342 black hat world
35343 hat black word 2
23525 word 2 black
1241 black 9 word
903 hat word

(focus on the number) i want to remove that random number in the first sentences, is there a fast way?

EternalFun · Oct 16, 2018

u scraped from this forum?

Rains · Oct 16, 2018

EternalFun said:
u scraped from this forum?

no, its just example

Keljmenc · Oct 16, 2018

Excel or notepad++ can do these easily.
Im writing on phone but if i remember correctly you can use delimiter command in excel. Delimited by space and delete first column...smthing like that.

Rains · Oct 16, 2018

Keljmenc said:
Excel or notepad++ can do these easily.
Im writing on phone but if i remember correctly you can use delimiter command in excel. Delimited by space and delete first column...smthing like that.

thx, i found it. browsing how to do in excell and found this formula =RIGHT(A1,LEN(A1)-3) . -3 means 3 word in the begining sentences will be removed

Keljmenc · Oct 16, 2018

Rains said:
thx, i found it. browsing how to do in excell and found this formula =RIGHT(A1,LEN(A1)-3) . -3 means 3 word in the begining sentences will be removed

I'm glad you find it

. But Excel>Data>Text to columns>Delimited is so, so useful... using all the time that why was my firs pick.

question - sort the data

Rains

Regular Member

EternalFun

Supreme Member

Rains

Regular Member

Keljmenc

Registered Member

Rains

Regular Member

Keljmenc

Registered Member

Main Menu

Marketplace

Making Money

BlackHat World