=RIGHT(A1,LEN(A1)-4)
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"KatieR" wrote:

I have a list of org unit names that are always preceded by a 3 digit number.
How can I just show the text and not the numbers?
Example: 001 Org Unit Name
*note* there is also always a space after the 3 digits.
In this example I only want a column to display "Org Unit Name."
Help?
KR
P.S. I looked through other posts and did not see anything readily similar.