| View previous topic :: View next topic |
| Author |
Message |
brianfay
OOo Enthusiast
Joined: 09 Jul 2003
Posts: 133
|
 Posted: Mon Apr 19, 2004 8:42 am Post subject: four pieces of data in one cell? |
 |
|
I would like to have four pieces of data appear in one cell of a spreadsheet, separated by commas. The data is called form another sheet in the set.
Three questions:
1. Is there a way to do this?
2. How?
3. What are the downsides to doing this? |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8983
Location: Lexinton, Kentucky, USA
|
| Posted: Mon Apr 19, 2004 10:47 am Post subject: |
|
|
| =A1 & "," & B1 & "," & C1 & "," & D1 |
|
| Back to top |
|
|
Guest
|
| Posted: Mon Apr 19, 2004 3:53 pm Post subject: Re: four pieces of data in one cell? |
|
|
| brianfay wrote: | I would like to have four pieces of data appear in one cell of a spreadsheet, separated by commas. The data is called form another sheet in the set.
Three questions:
1. Is there a way to do this?
2. How?
3. What are the downsides to doing this? |
Consider JohnV's answer. You will have a single text item which contains commas. You can not combine numericand text in any way in one cell to make it separable again, except by a lot of running around with string (text) and value functions.
David. |
|
| Back to top |
|
|
antonbijl
OOo Advocate
Joined: 04 Aug 2003
Posts: 291
Location: Pretoria, South Africa
|
| Posted: Tue Apr 20, 2004 7:19 am Post subject: Re: four pieces of data in one cell? |
|
|
| brianfay wrote: | | 1. Is there a way to do this? |
YES
See JohnV's answer above. You could also use =CONCATENATE(A1;B1;C1;D1)
| brianfay wrote: | | 3. What are the downsides to doing this? |
Depends on what the data is and what you're going to do with it. Why do you want to do this? What kind of data are we talking about? In some case the downsides would be too many to list here and in others there would be no downsides...
Cheers
Anton |
|
| Back to top |
|
|
brianfay
OOo Enthusiast
Joined: 09 Jul 2003
Posts: 133
|
| Posted: Fri Apr 23, 2004 4:59 pm Post subject: |
|
|
| Thanks, JohnV. That did what I wanted to do. |
|
| Back to top |
|
|
|
