HELP! Split text with Excel funcions

[gio123bg]

Hi All,
I' m trying to split this text (3 data with "*" as separator).

(blanks)AAAA(blanks)*(blanks)BBBB(blanks)*(blanks)CCCCCC


Let's suppose to have this text in cell B4

In cell B5 I have set this formula (to have only value AAAA) first field in a different column

=LEFT(TRIM(B4);SEARCH("*";B4))

In cell B6 I have set this formula (to have only value BBBB) second field in a different column

=TRIM(MID(TRIM(B4);SEARCH("*";TRIM(B4))+2;LEN(TRIM(B4))))

But +2 or +1 must not be set because the number of blanks is not defined

In cell B7 (last column for the split) .... I need Help.

Any suggestion for a different way to solve my problem will be well appreciated.

Thanks in advance for your kind support.

Regards,

Giovanni

 

[gio123bg]

Yes. All is ok now!

Thanks again for your kind support.

Regards,

Giovanni