Forum Discussion
Search/Find
How to delete a group of numbers next to names in a list (where the numerals can be from one to nine) e.g. 000000000|The First Time Group 000000000|The Second Time Group 000000000|The Third Tim...
As variant,
Select the cells you wish to separate the text. Go to the Data tab, Text to Columns, select Delimited, click Next, select Other and write "|", select Finish.
You will have two separated columns, one with the numbers (which you can delete if you wish) and another with only the text.