SafeFeel.com

Free Computer Networking Security & Software Questions and Answers Website

Excel give somebody the third degree: I call for to replace a manual from a column next to the set book surrounded by other column?

I've something resembling this:

http://spreadsheets.google.com/pub?key=p...

I involve to replace <<PRODUCTNAME>> keyword within the column "Product Description" near the merit within the cell of the subsequent column "Product Name".
Is in attendance any means of access to do that surrounded by Microsoft Excel?


Answers: Use the "Substitute" function.

Eg
=SUBSTITUTE (A1,"PRODUCTNAME",B1)

A1 = Product Description
B1 = Product name