This post will show you how to remove the first or last few characters or certain position characters from the text in Microsoft Excel.

The function should look something like this: "RIGHT (B2,4)." Remove text strings using Excel 2007's "Replace" command. Select all the cells in which you want to replace characters.

How to combine values into a single cell using TEXTJOIN () in Excel Microsoft 365, Excel 2019 and Excel for the web support the function, TEXTJOIN ().

Have you played with the "Text to Columns" function on the Data menu/tab yet? It's similar but not quite identical to the File Open text importer.