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 [email protected]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Reply via email to