Hi Everyone,

I've got text in cells that is as follows

Column A
Excel Microsoft
Microsoft Excel
etc
Is there a way i can seperate this column into columns B and C.
i.e. I want the Bolded values in column B and the non bold in column C

Column A                                Column B               Column C
Excel Microsft                          Excel                  Microsoft 
Microsoft Excel                         Microsoft              Excel
Cheers