Parsing problem with downloaded data

[Sir Vili]

Hi.

I have parsing problem with downloaded data. There should not be any problem to use Text to Column system, but after every text line (= long sentence) in row there are more lines and some blank lines in rows before new text to be parsed.

I only need names.

Here is example which is in one row in Excel:

BERNDTSSON, MIKAELA 1400 0530 1330 0530 1430 1000 1430 1430 0530 1300 1400 1400 1430 1100 1430 1100

So this long sentence in one row and I need only to get name BERNDTSSON, MIKAELA.

I have tested with formula:
LEFT(C1;SEARCH(",";C1;1)-1), but it gives me only last name BERNDTSSON not whole name BERNDTSSON, MIKAELA

Have anybody any idea to do this with formulas?

Regards Sir Vili.

 

[ChrisUK]

Glad you got it to work anyway!

The way I wrote it was it would look at a value in A1 and return the whole name into the cell where the formula was - which could be any cell.

All you have to do is copy the formula to the cells you want. In my sheet I had the data in cell A1 and the formula in cell B1. I've since added another 1000 rows of data into Cells A2 onwards and copied the formula from B2 onwards.

Worked fine for me.

Chris

 

[Sir Vili]

Hi Chris.

I had to use multiple If formulas to eliminate data I did not want to see when formula copied down.

Here is my final Formula if any body is interested:

IF(LEFT(C1,7)=" TAPSS ","",IF(LEFT(C1,2)="==","",IF(LEFT(C1,2)="--","",IF(LEFT(C1,4)="Duty","",IF(LEFT(C1,2)="id","",LEFT(C1,SEARCH("@",SUBSTITUTE(C1," ","@",2))-1))))))

So I thank You once more and everybody who helped me.

Sir Vili.
This message was edited by Sir Vili on 2002-10-15 08:07