help on Line Input statement

[napstar]

I have data in a txt file and it look like dis:
kevin 22 34 35
Mulan 56 45 9

i want to read dis data and get 20% of each number.
Line input reads the line but how do i manipulate each item in line?
Help please!!

[willakawill]

I have data in a txt file and it look like dis:
kevin 22 34 35
Mulan 56 45 9

i want to read dis data and get 20% of each number.
Line input reads the line but how do i manipulate each item in line?
Help please!!

Hi. You might investigate the Split() function

Dim arData As Variant

arData = Split(MyText, " ")

arData(0) will give you kevin
arData(1) will give you 22
etc