Looking for a Function? similar to LEFT

[KatieR]

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.

 

[rzink]

Try looking up the mid() function in Excel Help. Assuming your original unit
name with numbers is in A1: =MID(A1,5,20). Adjust the 20 to match the
longest possible unit name.

Here is the syntax: =MID(text,start_num,num_chars).

OR

You could also use the text-to-columns feature and designate your data in
the Text to Columns Wizard as space delimited.

Hope this helps.

rzink

 

[Don Guillett]

Several ways

=right(a2,len(a2)-4)

 

[Chip Pearson]

Another way is

=MID(A1,FIND(" ",A1)+1,999)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com

 

[Harlan Grove]

Another way is

=MID(A1,FIND(" ",A1)+1,999)

....

Good to use the delimiter. Possible to dispense with the 999.

=REPLACE(A1,1,FIND(" ",A1),"")