The “&” symbol is used to link different text string together.The Concat function, previously known as “concatenate”, will fully replace the concatenate function in the next version of Excel.There are two primary means of joining text in Excel: Note: The Text to Columns feature overwrites data in the column(s) to the right so be sure to Insert the proper number of columns before performing the action. Fixed Width-click where the cell should split.
Select Delimited or Fixed Width and click Next.DATA > Data Tools group > Text To Columns.Splitting Dataĭata in a cell can be split into separate, adjoining cells based on a character that separates the parts, such as a space between the first and last name, or after a specified number of characters. Knowing how to split and join text in Excel is a highly useful skill that will allow you to work efficiently and accurately.
