replace text in cell that already has text

P

Peter

Is it possible to replace existing text in a cell with new text derived from
an argument in another cell. For example, if cell A1 contains the text "CAR"
could cell B2 perform a function to determine the type of car and then the
result, say "FORD", is pasted into cell A1 to replace it?
Thanks
Peter
 
M

Myrna Larson

A formula can only return a value to the cell that contains the formula. It
can't change another cell.

You can put your formula in another column, copy the formulas and Edit/Paste
Special and select the Values option. You want to paste over the formulas
themselves. Then you can delete the original column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Visio shape text disappears upon copy paste 1
formula similar to "countifs" function in excel 2007 2
Can UDF return a customized hyperlink? 3
Replace text with text 0
function to give me cell reference 5
use cell text in lookup function 3
Find certain text in a cell 3

Top