Sperate words and remain formats

%3CLINGO-SUB%20id%3D%22lingo-sub-2371151%22%20slang%3D%22en-US%22%3ESperate%20words%20and%20remain%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2371151%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20split%20a%20column%20of%20data%20%2Ce.g.%26nbsp%3B%3CEM%3ELivistona%26nbsp%3Bchinensis%3C%2FEM%3E%26nbsp%3B(Jacq.)%20R.%20Br.%20ex%20Mart.%3C%2FP%3E%3CP%3Einto%20two%20column%20and%20remain%20the%20format%20by%20using%20formula%3F%3C%2FP%3E%3CP%3Eone%3A%26nbsp%3B%3CEM%3ELivistona%26nbsp%3Bchinensis%3C%2FEM%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eanother%20one%3A%26nbsp%3B(Jacq.)%20R.%20Br.%20ex%20Mart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ee.g.%3C%2FP%3E%3CTABLE%20width%3D%22765%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22311%22%3EScientific%3C%2FTD%3E%3CTD%20width%3D%22227%22%3ESCI_PRE1_ITA%3C%2FTD%3E%3CTD%20width%3D%22227%22%3ESCI_SUF1_REG%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELitsea%20monopetala%20(Roxb.)%20Pers.%3C%2FTD%3E%3CTD%3ELitsea%20monopetala%3C%2FTD%3E%3CTD%3E(Roxb.)%20Pers.%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2371151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2371209%22%20slang%3D%22en-US%22%3ERe%3A%20Sperate%20words%20and%20remain%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2371209%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1058704%22%20target%3D%22_blank%22%3E%40Minnie_299%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20cannot%20do%20that%20using%20built-in%20Excel%20functions.%20It%20would%20require%20a%20macro%2C%20or%20custom%20VBA%20functions.%3C%2FP%3E%0A%3CP%3EWill%20your%20cells%20always%20have%20a%20first%20part%20in%20italics%2C%20then%20the%20rest%20in%20standard%20text%3F%3C%2FP%3E%0A%3CP%3EOr%20could%20there%20be%20a%20different%20pattern%2C%20or%20do%20you%20also%20need%20to%20take%20other%20formatting%2C%20such%20as%20bold%2C%20underline%20or%20font%20color%20in%20consideration%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2385586%22%20slang%3D%22en-US%22%3ERe%3A%20Sperate%20words%20and%20remain%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385586%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1058704%22%20target%3D%22_blank%22%3E%40Minnie_299%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1621980957052.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283737i42B96F7FA4B59AA3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1621980957052.png%22%20alt%3D%22Yea_So_0-1621980957052.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eand%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_1-1621981007226.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283738i65C2B386A793CB65%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_1-1621981007226.png%22%20alt%3D%22Yea_So_1-1621981007226.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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