You are not logged in.

OpenOffice - Spreadsheet

Dear visitor, welcome to KDE-Forum.org. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

stumbles

Beginner

  • "stumbles" started this thread

Posts: 5

Location: Black Mountain, NC

  • Send private message

1

Thursday, July 3rd 2003, 9:56pm

OpenOffice - Spreadsheet

I have a column with names and I want to separate the first and last names so they are in their own columns. Any idea how to do this without a manual edit? Heres a sample list;

'Nina Steve Smith'
'Eric Tangeman'
'Karen Corson'
'Mike Hiett'
'Sara Whittaker'
'Mark Gillett'
'Gary Zeller'
'Bob Lies'
'John Harmon'
'Todd Harruff'
'Glen Krites'
'Greg Gossman'
'Dwight Hartman'
'Max Evans'
'Hugh Core'
'John Elliott'
'John Morris'
'Brent Myers'
'David Fox'
'Ronald Ball'
'Kenneth Rozell'
'Jerry Hesseling'
'Kevin Williams'
'Elaine Troyer'
'Doug Bell'

thuswa

Beginner

Posts: 24

  • Send private message

2

Friday, July 4th 2003, 10:56am

Re: OpenOffice - Spreadsheet

Quoted

Original von stumbles

I have a column with names and I want to separate the first and last names so they are in their own columns. Any idea how to do this without a manual edit? Heres a sample list;

'Nina Steve Smith'
'Eric Tangeman'
'Karen Corson'
'Mike Hiett'
'Sara Whittaker'
'Mark Gillett'
'Gary Zeller'
'Bob Lies'
'John Harmon'
'Todd Harruff'
'Glen Krites'
'Greg Gossman'
'Dwight Hartman'
'Max Evans'
'Hugh Core'
'John Elliott'
'John Morris'
'Brent Myers'
'David Fox'
'Ronald Ball'
'Kenneth Rozell'
'Jerry Hesseling'
'Kevin Williams'
'Elaine Troyer'
'Doug Bell'


That's one of the stupid things about OO. A tabbed delimited list is automatically divided into seperate columns but you don't have a seperate "text to column" option under tools (like Excel does) instead it is placed in OO writer, there you have an option to divid text into a table. I really don't get it myself.
Ofcorse I use windows, how else would I get fresh air into the room?

Rinse

Professional

Posts: 797

  • Send private message

3

Wednesday, July 23rd 2003, 2:57am

You can use a script to create a csv file which you import in OOo Calc


Rinse
Help mee om KDE 3.5.5 in het Nederlands te vertalen

smooth_hound

Beginner

Posts: 25

  • Send private message

4

Wednesday, July 23rd 2003, 9:14am

You can simply highlight the list and then do a middle button paste into an open oocalc spreadsheet. It should then open a dialog asking about delimiters, change the delimiter to space and it should paste it sensibly.

:)