Link to home
Start Free TrialLog in
Avatar of rutgermons
rutgermons

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Simon
Simon
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial