Trouble finding the Split Text Function on Google Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1660778%22%20slang%3D%22en-US%22%3ETrouble%20finding%20the%20Split%20Text%20Function%20on%20Google%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660778%22%20slang%3D%22en-US%22%3E%3CP%3ESplit%20text%20function%20does%20not%20appear%20please%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MintPatty_1-1599932682810.png%22%20style%3D%22width%3A%20554px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217985i3591D52BBF536778%2Fimage-dimensions%2F554x182%3Fv%3D1.0%22%20width%3D%22554%22%20height%3D%22182%22%20title%3D%22MintPatty_1-1599932682810.png%22%20alt%3D%22MintPatty_1-1599932682810.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1660778%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%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660948%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20finding%20the%20Split%20Text%20Function%20on%20Google%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791432%22%20target%3D%22_blank%22%3E%40MintPatty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EText%20to%20Columns%20is%20not%20available%20in%20Excel%20Online%20by%20default.%3C%2FP%3E%0A%3CP%3EYou%20can%20either%20edit%20your%20workbook%20in%20the%20desktop%20version%20of%20Excel%2C%20or%20install%20the%20free%20%3CA%20href%3D%22https%3A%2F%2Fappsource.microsoft.com%2Fen-us%2Fproduct%2Foffice%2FWA104379942%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESplit%20Text%20to%20Columns%3C%2FA%3E%20add-in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660961%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20finding%20the%20Split%20Text%20Function%20on%20Google%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660961%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791432%22%20target%3D%22_blank%22%3E%40MintPatty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20far%20there%20is%20no%20text%20split%20function%20in%20Excel.%20Have%20no%20idea%20about%20Google%20Sheets.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Split text function does not appear please help.

 

MintPatty_1-1599932682810.png

 

2 Replies

@MintPatty 

Text to Columns is not available in Excel Online by default.

You can either edit your workbook in the desktop version of Excel, or install the free Split Text to Columns add-in.

@MintPatty 

So far there is no text split function in Excel. Have no idea about Google Sheets.