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.

 

e.g.

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

@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?

Hi @Minnie_299 

Like this?

Yea_So_0-1621980957052.png

and this?

Yea_So_1-1621981007226.png