Excel - Replacing Text String With Other Text 1

[beanxx]

If cell A1 = "Answer_A" or "Answer_B" how do I get cell B1 to return "Answer A" or "Answer B", with the underscores removed. I guess I need to use some form of IF statement, but I'm not sure how to implement this. Can anyone help?

Justin

 

[xlbo]

=SUBSTITUTE(A1,"_"," &quot
where your text is in A1 will do the trick

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[Molby]

Why don't you seperate out the text that you want using the LEFT and RIGHT functions. You can then use the CONCATERNATE formula to add the info back together including a space.

Or do a find and replace on the _ character with a space character.

Regards,

Ian

 

[beanxx]

Geoff, Works a treat thanks very much and well worthy of a star!

Thanks a lot,

Justin