Re: [libreoffice-users] Convert formulae to actual

Stefan Weigel <stefan.weigel -AT- bildungskreis.org>

Mon, 21 Mar 2011 22:14:06 +0100

Hi, Am 21.03.2011 17:59, schrieb James Wilde:

I have a calc sheet with full names in one column, thus:

John Smith
Jane Smollett

I want to create a column with forenames and one with surnames.

No need for formulae. Have a look at: "Data | Text to Columns..." See: http://help.libreoffice.org/Calc/Text_to_Columns Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+help@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***

Context

Re: [libreoffice-users] Convert formulae to actual · Stefan Weigel

Re: [libreoffice-users] Convert formulae to actual · James Wilde

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.