Viewing data from one column within one single cell ?

[Guest]

(Excel 2003)
Hi,
I'm trying to find out how to move data with it's headers into one single
cell block?
For example: If I have 3 colomns with headers: Name Surname Age
with data: Mark
Peters 37

How can I move all headers with data to one single cell For example:
Name: Mark, Surname: Peters, Age: 37

Any ideas would be most appreciated,
Regards,
MAC

 

[Doug Kanter]

(Excel 2003)
Hi,
I'm trying to find out how to move data with it's headers into one single
cell block?
For example: If I have 3 colomns with headers: Name Surname Age
with data: Mark
Peters 37

How can I move all headers with data to one single cell For example:
Name: Mark, Surname: Peters, Age: 37

Any ideas would be most appreciated,
Regards,
MAC

Experiment (don't do this on an important sheet until you see what it does):

Insert, Function, choose "All", then in the list on the right, click the
"Concatenate" function and click next or OK. That function allows you to
create a chunk of text from pieces in other cells. Pretty easy, actually.
Just be sure to put spaces between the various chunks, if necessary. You do
that by enclosing a space in quotes:
" "

You can also put things like dashes or commas between the quotes.

 

[Doug Kanter]

Experiment (don't do this on an important sheet until you see what it
does):

Insert, Function, choose "All", then in the list on the right, click the
"Concatenate" function and click next or OK. That function allows you to
create a chunk of text from pieces in other cells. Pretty easy, actually.
Just be sure to put spaces between the various chunks, if necessary. You
do that by enclosing a space in quotes:
" "

You can also put things like dashes or commas between the quotes.

Forgot to mention this: In the boxes provided by the Insert Function thing,
you use cell references like A1, D3 to pick up the values of the cells whose
text you want to use.

 

[Guest]

Well, you could do this with a formula:-

="Name: "&A2&", Surname: "&B2&", Age: "&C2

but that could change if the original cells are amended. Or with a simple
macro:-

Range("E2").Select
ActiveCell.Value = "Name: " & Range("A2") & ", Surname: " & Range("B2")
& ", Age: " & Range("C2")

which will end up with the required value