Inserting text into a sentence from another cell

[sobrien]

I am trying to insert text from another cell into a sentence. For example I would like text from B1 to be inserted in text in A1 as follows:

Your current Deployer is B1

Thanks

 

[repairman615]

Hello,

Try:

<TABLE style="WIDTH: 203pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=270><COLGROUP><COL style="WIDTH: 203pt; mso-width-source: userset; mso-width-alt: 4937" width=270><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #c2d69a; WIDTH: 203pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl65 height=21 width=270>="Your current Deployer is " &B1

</TD></TR></TBODY></TABLE>

 

[brockk]

Hi:

Try this:

="Your current Deployer is "&B1

 

[sobrien]

Thanks - brilliant!!

 

[vr4Legacy]

I have a follow up to this. I am trying to insert a time into my sentence, however the time is entered as a data value in the other cell (i.e. 5:00pm = .7)

Here is what I am using

="Work " &D2

and it returns (Work .7)

Where D2 = the time value of 17:00

Is there a way I can keep the formatting from the source cell?

thanks!

 

[vr4Legacy]

I played around in help and found my own answer

="Work "&TEXT(D2,"[$-409]h:mm AM/PM")

That now returns

Work 5:00PM

Thanks anyway, I'm glad I found this forum, there is a lot of great info here, I'm sure I'll be browsing through it.

 

[CWatts]

Check out the podcasts. Some pretty neat stuff in there.