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. ... (examples not copied)
If you're by any chance waiting for an answer, you will note that you've had quite a few views without any responses. The reason: your posting doesn't fully make sense.
You've got a string of nine zeroes in front of each set of words, divided from them by "|" (a vertical line).
You say the numerals that you want to range from 1 to 9 (zero, of course, is not within that range; so are you saying there may be anywhere from one number up to nine numbers, or something else?
In any event, if that vertical line is always present, separating the digits from the text that you want to remain, then a formula could be used quite easily--in a separate column--regardless of the number of digits
=RIGHT(A3,LEN(A3)-FIND("|",A3))