Solved

Edit value

Posted on 2011-02-20
3
213 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:sandramac
  • 2
3 Comments
 
LVL 50

Expert Comment

by:teylyn
ID: 34938796
Hello,

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

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"BR",""),"FG",""),"HZ",""),"BL","")

cheers, teylyn
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 34938805
You might also want to add a TRIM function to that, teylyn, otherwise some trailing/leading spaces may remain....

regards, barry
0
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
ID: 34938892
Good catch, barry.

Just wrap a trim() around it

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"BR",""),"FG",""),"HZ",""),"BL",""))
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now