Remove Text
Brandon wrote:
I need a function to remove text from a cell and leave 5 digits at the very
end of the string.
For example:
Company One 11111
Company 2 22222
Com Three 33333
Co. Four 44444
Co. 5 55555
What is to the left of the numbers that I need to keep varies in length. So
I need to remove everything that isn't the furthest right 5 characters in the
string.
Any help is greatly appreciated. Thank you in advance.
Brandon
=RIGHT(A1,5)
|