Seperating text into 3 columns

[Colleen45]

I have a list of texts of varying lengths, always seperated by the "first space" and then by a semi-colon

Sample
CTL3-Harare_bejnf [=Book - English juvenile non fiction];2417
CTL3-Harare_bejt [=Book - English juvenile Teens];155
CTL3-Harare_belp [=Book - English fiction large print];764


I'm battling to create formulas that will put this in 3 Columns, seperated by the "first space" and then by the semi-colon - The "first space" and the sem-colon must be omited from the results.

 

[Colleen45]

Thanks Anandvarma, this removes the leading space in the second column
Thank you Peter for your help

Blessings
Colleen

 

[anandvarma]

Use trim function

 

[anandvarma]

i am glad it helped you