• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Edit value

Hello I have a values that I need to evaluate, but what I need to do is if there is a BR FG HZ or BL then ignore that and display the other values example below

RAPL BR   need just RAPL
TSRA FG   need just TSRA
RABR  need just BR
SHRA FG need just SHRA
BLSN FG  need just SN
  • 2
1 Solution
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

can you check your data sample again?

>> RABR  need just BR

Should that not be RA as the result?

Are these values in cells in a worksheet? If so, try


cheers, teylyn
barry houdiniCommented:
You might also want to add a TRIM function to that, teylyn, otherwise some trailing/leading spaces may remain....

regards, barry
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Good catch, barry.

Just wrap a trim() around it

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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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