Viewing data from one column within one single cell ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
MAC said:
(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
Click to expand...

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 said:
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.
Click to expand...

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.
 
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
 
Back
Top