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.
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.