Formulas

[Ted Maynard]

Is it possible to have a formula pull information from a
different cell and also have text.

Example: Cell B3 = 35.00

Then I would want cell C1 to have it say Sam sold 35.00.
t will pull the value from the cell, but already have the
text there.

Thanks,

Ted

 

[James S]

Hi Ted,

Try using the formula below in Cell C1.

="Sam sold " & B3

Hope that helps.

Regards,
James S