Substitute Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a formula which will allow me to substitute/delete text that
appear in numbers. ie HKD-2,500.00 or YEN-2,500.00. I have used the
substitute formula but it will only delete one of the text's specified but I
want it to pick one or the other
ie HKD/YEN. Can the substitute formula be nested if so how?
 
Could you, instead, just return the number after the dash?:
A1: HKD-2,500.00
B1: =--MID(A1,FIND("-",A1)+1,255)
(returns 2500)


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
=SUBSTITUTE(SUBSTITUTE(A1,"YEN",""),"HKD","")
if you mean this!

Regards,
Stefi

„AmyD†ezt írta:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula, Pivot Table, ??? Beats me 2
Convert currency within column 1
Nesting the SUBSTITUTE formula 4
Excel VBA 1
To remove numbers in a cell with out using the macro 3
Substitute 7
Formula help 1
non-VBA Alternative to SUBTITUTE function 6

Back
Top