Extracting Part of Value in Excel

Hello EE,

Can some please help me an excel formula to extract Malu Yokohama from Malu Yokohama ?Yokohama ??????

Thanks
LVL 1
fb1990Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try
=TRIM(LEFT(A1,FIND("?",A1,1)-1))

Open in new window

Regards
0
 
fb1990Author Commented:
Worked like charm!  Thank you.  I added iferror to mask any non confirming text.
0
All Courses

From novice to tech pro — start learning today.