Find and replace a character with another cell contents

**tcapewell** · 07-12-2010, 07:26 AM

Hello all,

I'm sure this is an easy fix, but as I haven't used excel for a while and have had no luck looking searching the forum I'm going to need to ask for help

I need to do a kind of find and replace scenario, however I don't think I can use this standard function for my requirements. I've also tried the IF function without success.

I want to find all instances of the character * in Column A and replace it with the contents of the cell immediately to the right (in Column B).

ANy help, much appreciated.

Thanks

**arthurbr** · 07-12-2010, 07:31 AM

In c1 enter =substitute(a1,"*",b1)

**tcapewell** · 07-12-2010, 07:46 AM

Perfect!!

Thanks arthurbr

**tcapewell** · 07-12-2010, 09:46 AM

Is there an extension to this function which makes it possible to move the data from B1 instead or delete the content once the formula has been realised, leaving Column B empty?