excel trim requird

folks

need to remove all characters in a formula on value in column A after the full word on the left i.e.

test-
test
test-bckup
test-b1
test-b23

should only show test

trial-
trial-bkuo
trial-12345

should only show trial

car
car-12
car-ss

should only show car

all help will do
rutgermonsAsked:
Who is Participating?
 
SimonConnect With a Mentor Commented:
If your data is in column "A", put this in B1.

=IFERROR(LEFT(A1,FIND("-",A1)-1),A1)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.