How do I link text and a formula together?

[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

 

[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

 

[Frank Kabel]

Hi
try
=your_formula & " Housing Population"

 

[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

 

[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

 

[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.