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

Originally Posted by teylyn

Sorry, I'm not sure I understand. What is that code you have there? Is that the string where you want to replace "bebo"?

If that string is in A1, use

=substitute(A1,"bebo", B1)

No this line is in cell A1
CREATE TABLE IF NOT EXISTS `(=B1)` ( `id` int(10) NOT NULL auto_increment,`beboid` varchar(255) default '0',`status` varchar(255) default 'No Comment Posted',PRIMARY KEY (`id`))

and i want to replace the string "bebo" with what ever is in B1 and then when thats done i want to drag column A1 down to A2 A3 A4 etc replacing bebo with the values in B1 B2 B3 B4 etc..

Can this be done?

Originally Posted by teylyn

Sorry, I'm not sure I understand. What is that code you have there? Is that the string where you want to replace "bebo"?

If that string is in A1, use

=substitute(A1,"bebo", B1)

ok thanks that worked but it also replace the "beboid" as well which i dont want to happen

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`))

Originally Posted by DonkeyOte

Use "`bebo`" not "bebo" in the Substitute.

ok thanks..

any ideas how to type this ` symobol as appose to this symbol '