Return the characters after Nth character in a string

Question

I need help  Can someone please let me know how to return the characters after the nth character   For example  the strings I have is  001 baseball  and  002 golf   I want my code to return baseball and golf  not the number part  Since the word after the number is not always the same length  I cannot use    Right String  n   Any help will be greatly appreciated

User · Answer

If your numbers are always 4 digits long:

=RIGHT(A1,LEN(A1)-5) //'0001 Baseball' returns Baseball

If the numbers are variable (i.e. could be more or less than 4 digits) then:

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) //'123456 Baseball’ returns Baseball

User · Answer

Another formula option is to use REPLACE function to replace the first n characters with nothing  e g  if n   4   REPLACE A1 1 4

User · Answer

Mid strYourString  4   i e  without the optional length argument  will return the substring starting from the 4th character and going to the end of the string

User · Answer

Alternately  you could do a Text to Columns with space as the delimiter

User · Answer

Since there is the  vba  tag  split is also easy   str1    001 baseball  str2   Split str1    Then use str2 1

[excel] Return the characters after Nth character in a string

Examples related to excel

Examples related to vba