Extract Words to left of a Symbol (If the symbol exists)

Hi new member here. Can anyone offer any help on this please?

I'm trying to create a formula that will effectively remove the Pipe symbol, the spaces at both sides of the Pipe symbol and everything after it. Not all cells contain a Pipe symbol, in that case the contents of that cell are good to go. So I guess =IF needs to be used with =LEFT and =SEARCH. I just can't get it to work.

The top list is the original and bottom list is what I'm after.

Many thanks

EBT63765712 | EAX66482504(1.0)
EAY63630201 | EAX66171501(2.0)
6871L-3806D | 6870C-0532A
RSAG7.820.7962/ROH
RSAG7.820.7748/ROH
55T32-C0F | UZ-5550T32C11
EBT64446702 | EAX67133404(1.0)
EAY64511101 | EAX67189201(1.6)
1-883-753-12
1-883-917-11
EDL_4LV0.3
1-883-300-11 | 1-732-438-11
BN94-12644A | BN41-02568B
BN44-00807F
BN94-12438C | BN41-02568B
BN44-00807A


EBT63765712
EAY63630201
6871L-3806D
RSAG7.820.7962/ROH
RSAG7.820.7748/ROH
55T32-C0F
EBT64446702
EAY64511101
1-883-753-12
1-883-917-11
EDL_4LV0.3
1-883-300-11
BN94-12644A
BN44-00807F
BN94-12438C
BN44-00807A

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new, I have done it for you this time.)

=IFERROR(TRIM(LEFT(A2,SEARCH("|",A2)-1)),A2)

will do thta.

Try this:

=IFERROR(LEFT(A1,FIND(" |",A1)-1),A1)

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.