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

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

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

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

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

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

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

Examples related to excel

Examples related to vba