Forula needed to replace a word in one column with another word in a different cell

in excel i want to replace the word bebo with a value in cell B1
this is the line
CREATE TABLE IF NOT EXISTS `bebo` ( `id` int(10) NOT NULL auto_increment,`beboid` varchar(255) default '0',`status` varchar(255) default 'No Comment Posted',PRIMARY KEY (`id`))

in column B i have a load of values
so i need an excel formula to replace bebo
so that it will take values from B1 to B26
any ideas please?