Sperate words and remain formats

Occasional Visitor

How to split a column of data ,e.g. Livistona chinensis (Jacq.) R. Br. ex Mart.

into two column and remain the format by using formula?

one: Livistona chinensis 

another one: (Jacq.) R. Br. ex Mart.



Litsea monopetala (Roxb.) Pers.Litsea monopetala(Roxb.) Pers.
2 Replies


You cannot do that using built-in Excel functions. It would require a macro, or custom VBA functions.

Will your cells always have a first part in italics, then the rest in standard text?

Or could there be a different pattern, or do you also need to take other formatting, such as bold, underline or font color in consideration?

Hi @Minnie_299 

Like this?


and this?