[Solved] Split cell contents to 2 cells

Discuss the spreadsheet application

[Solved] Split cell contents to 2 cells

Postby wlf3rd » Fri May 08, 2020 12:13 am

i have a LONG list of names - all within one cell/column... i need to separate them to make 2 columns. is there any easy way to do so, i've not found one. :(

ie: JOHN SMITH needs to become "JOHN" "SMITH" ... in two separate cells


any help would be welcome, i do not want to spend days duplicating columns and erasing 1/2 in each. thanks in advance.
Last edited by MrProgrammer on Fri May 08, 2020 8:59 am, edited 2 times in total.
Reason: Changed subject, was: reordering cell contents ??; Tagged ✓ [Solved]
openoffice 4.1.5 on Windows 10
wlf3rd
 
Posts: 2
Joined: Fri May 08, 2020 12:07 am

Re: reordering cell contents ??

Postby MrProgrammer » Fri May 08, 2020 1:26 am

Hi, and welcome to the forum.

As long as you have two words per cell, [Tutorial] Text to Columns will do this easily. Of course it has no way to distinguish cases like Nancy Ann Cianci (two word first name) and Martin Van Buren (two word last name).

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3868
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: reordering cell contents ??

Postby wlf3rd » Fri May 08, 2020 1:29 am

that should work, will have to clean some up that have 3 names...thanks so much.
openoffice 4.1.5 on Windows 10
wlf3rd
 
Posts: 2
Joined: Fri May 08, 2020 12:07 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests