Sperate words and remain formats

[Minnie_299]

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.

e.g.

Scientific	SCI_PRE1_ITA	SCI_SUF1_REG
Litsea monopetala (Roxb.) Pers.	Litsea monopetala	(Roxb.) Pers.

[#2]

@Minnie_299 

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?

[#3]

Hi @Minnie_299 

Like this?

and this?