How do I link text and a formula together?

  • Thread starter Christine Wilso
  • Start date
C

Christine Wilso

How do I link text and a formula together?

I want the the words "Sheffield Housing Population" to appear in on
cell, however the words 'Housing Population' remains constant, whils
the area will change to Doncaster, Rotherham etc depending on the dat
I recieve. This data is headed Sheffield, Doncaster, etc so how do
keep changing this name whilst including the words 'Housing Population
immediately after the area
 
J

JulieD

Hi Christine

it depends a bit on how your data is set up .. if each worksheet is a
separate area & the area's name appears in cell A1 then
=A1 & " Housing Population"

will work for you.

Cheers
JulieD
 
B

Bölcskei

Hi!

use CONCATENATE excel function.

=CONCATENATE(C2;$C$3) when C2 will contain results like Sheffield o
Doncaster and C3 will contain "Housing Population
 
J

JulieD

Hi

if you're using the CONCATENATE function as suggested by Bölcskei, depending
on your regional settings the syntax may be
=CONCATENATE(C2,$C$3) or you could just use
=CONCATENATE(C2," Housing Population")

Cheers
JulieD
 
E

Earl Kiosterud

Christine,

You may be able to use number formatting, believe it or not. Try Format -
Cells - Number tab - Custom:

;;;General "Housing Population"
@ "Housing Population"

This will append " Housing Population" onto anything placed into the cell
(like Sheffield), unless the cell is empty. The cell can have a formula
linking to another cell, too, like =B2, to pick up the data.
 
Top