Formulas

T

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
 
J

James S

Hi Ted,

Try using the formula below in Cell C1.

="Sam sold " & B3

Hope that helps.

Regards,
James S
 

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

Newbie Help - IF Yes No Function 0
Excel does not accept text format! 0
Adding cells until they are greater than a lookup cell and returning a value 1
Excel - Wich Function should I use? 1
Converting a number into a cell reference 2
Using Sumproduct when some of the values are null 5
Copy addition formula of non-consecutive horizontal cells 2
VBA Coding Help for Beginner 0

Top