Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 44
  • Last Modified:

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
0
fb1990
Asked:
fb1990
1 Solution
 
Rgonzo1971Commented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now