OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

four pieces of data in one cell?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
brianfay
OOo Enthusiast
OOo Enthusiast


Joined: 09 Jul 2003
Posts: 133

PostPosted: Mon Apr 19, 2004 8:42 am    Post subject: four pieces of data in one cell? Reply with quote

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
View user's profile Send private message Visit poster's website
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Mon Apr 19, 2004 10:47 am    Post subject: Reply with quote

=A1 & "," & B1 & "," & C1 & "," & D1
Back to top
View user's profile Send private message
Guest






PostPosted: Mon Apr 19, 2004 3:53 pm    Post subject: Re: four pieces of data in one cell? Reply with quote

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
OOo Advocate


Joined: 04 Aug 2003
Posts: 291
Location: Pretoria, South Africa

PostPosted: Tue Apr 20, 2004 7:19 am    Post subject: Re: four pieces of data in one cell? Reply with quote

brianfay wrote:
1. Is there a way to do this?

YES

brianfay wrote:
2. How?

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
View user's profile Send private message
brianfay
OOo Enthusiast
OOo Enthusiast


Joined: 09 Jul 2003
Posts: 133

PostPosted: Fri Apr 23, 2004 4:59 pm    Post subject: Reply with quote

Thanks, JohnV. That did what I wanted to do.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group