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

Conversion of cell formula to the formula result

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


Joined: 28 Oct 2011
Posts: 2
Location: Canada

PostPosted: Fri Oct 28, 2011 12:20 pm    Post subject: Conversion of cell formula to the formula result Reply with quote

I have several text cells in a row. I have consolidated those cells in to one cell using concatenation and reference to each cell. I want to be able to erase the individual cells but when I do that the consolidated cell collapses. Is there a way to take the consolidated cell and convert it's content to just text without out reference to the original cells?

Mike
Back to top
View user's profile Send private message AIM Address MSN Messenger
Ed
Super User
Super User


Joined: 28 May 2003
Posts: 1041

PostPosted: Fri Oct 28, 2011 1:43 pm    Post subject: Reply with quote

Copy the cell with the formula result in it then go to Edit>Paste Special (or press Ctrl-Shift-V). In the dialog that appears unselect "Paste all", then make sure "Numbers" is selected (if applicable) and "Formulas" is not. Now press OK and accept the warning about pasting into a cell that already contains data.
Back to top
View user's profile Send private message
cncorbust
Newbie
Newbie


Joined: 28 Oct 2011
Posts: 2
Location: Canada

PostPosted: Fri Oct 28, 2011 5:45 pm    Post subject: Reply with quote

Thanks, that was quick.

Now my next question is...How do I do that over a range of cells (over one hundred). Will it require a macro or is there some other easier way to do a repetative action?

Where can I get "the book" on macroes, it seems that some of the URLs offering "the Book" are not working?

Mike
Back to top
View user's profile Send private message AIM Address MSN Messenger
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Fri Oct 28, 2011 6:03 pm    Post subject: Reply with quote

Hi,

Copy the range of cells and proceed as Ed answered.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
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