How to TRIM characters to the LEFT of a special character?

[binar]

Fellow Forum Members,
The function below was posted by a member of this forum and it removes characters to the right of the last occurance of a special character:

=TRIM(LEFT(A1,FIND("$",SUBSTITUTE(A1,"|","$",LEN(SUBSTITUTE(A1,"|","%%"))-LEN(A1)))-1))

I would be very grateful if anyone out there can help me tweak this function so that it removes all characters to the LEFT of a special character (no last occurence needed since it only shows up one time). The special character in this case is an underscore "_"

For example:

xxxxxxx_13405050 converts to: _13405050
or
xrrkdkkwwppp_1230 converts to: _1230

Any help will be greatly appeciated. Thanks.

 

[VoG]

Try

=RIGHT(A1,LEN(A1)-FIND("_",A1)+1)

 

[lenze]

Try this

=IF(A1<>"",RIGHT(A1,LEN(A1)-FIND("_",A1)+1),"")

lenze

 

[binar]

Lenze and VOG,
Thank you very much for your prompt posts. Both formulas work perfectly. And they seem to be a lot less complicated than the one I was focused on tweaking. It makes one wonder when the TRIM function is the right tool for the job. Agan thanks for the help to solve this problem.

 

[MrKowz]

The TRIM function is used to eliminate leading and trailing spaces. The part that actually truncates the function is the LEFT/MID/RIGHT formulas.

 

[Scott Huish]

=replace(a1,1,find("_",a1&"_")-1,"")

 

[Dick3]

This worked great, thanks