Truncate vaiable text strings???

[esponapule]

Is there a formula to remove everything after a certain character for variable text strings?

for example:

Turnthis...

Single basin|,Double basin|,Triple basin|
Double handle|,Single handle|,Touchless|
Single hole|,Two holes|,Three holes|,Four holes|,Single hole with deck plate|

into this:

Single basin
Double handle
Single hole

Thanks!

 

[VoG]

Try

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

 

[esponapule]

THAT WORKED!!!

I had to change it a little, a1 is the result so I used col. B

THANKS!! I also learned a new command too!

awesome

 

[Scott Huish]

Now, if you have some strings that don't have the | character, you will want to do this instead:
=LEFT(B1,FIND("|",B1&"|")-1)

Excel Workbook
	B	C
1	Single basin|,Double basin|,Triple basin|	Single basin
2	Double handle|,Single handle|,Touchless|	Double handle
3	Single hole|,Two holes|,Three holes|,Four holes|,Single hole with deck plate|	Single hole
4	Single Basin	Single Basin
Sheet1