How to insert the value of a cell into a string?

  • Thread starter Thread starter Peter Reaper
  • Start date Start date
P

Peter Reaper

I want to say something like:

"Contract No.: " + Cell:B4

which would result in:

Contract No.: 12345

I know this is possible, I just cant find it. Any help would be
appreciated. :)

--

Regards,

Peter Reaper

--==--
The Wizard of Moz (www.mozilla.org)
--==--
 
Andy said:
Try:
="Contract No.: "&B4
Click to expand...

Thanks Andy, that worked. :-D

After posting i found another solution:

="Contract No.: "&TEXT(proposal!D4;"#")

but it is more complicated that your solution. (the # was to make blank
D4 cells not add a zero)
 
Back
Top