Multiple data in a single column. need to extract the indivitual data..
i need to use the excel file that has data in a single column , single row like:
"60.00000000 4993.08359390 -1072.91939781 4757.18964226 -5.233862561 -0.282145111 -5.442921539"
now i need to use first 4 values individually that are:
where each , represents a blank space.
W=60.00000000; X=4993.08359390; Y=-1072.91939781; Z=4757.18964226;
one thing to not is that there are 4 blanks between each value but if the next value is negative then there are 3 blanks.
how is it suggested that i do that.
NOTE: i have many rows. i will increment row at each loop.
as a total beginner so a simplified answer will be appreciated..
thanks in advance