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...
jdecreative To add to the collection:
=TEXTAFTER(A1,"|")where A1 contains a text string like "000000000|The First Time Group".
https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4
Riny_van_Eekelen jdecreative MAngosto
As always, there are multiple ways to get from problem to solution in Excel. And (to me) a reminder that there are always new, more efficient, ways being created. My use of RIGHT and LEN is an old school solution; TEXTAFTER is a newer one, so I'm thankful to Riny_van_Eekelen for that introduction.
