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.
[Solved] Split cell contents to 2 cells
[Solved] Split cell contents to 2 cells
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.
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]
Reason: Changed subject, was: reordering cell contents ??; Tagged ✓ [Solved]
openoffice 4.1.5 on Windows 10
-
MrProgrammer
- Moderator
- Posts: 5283
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: reordering cell contents ??
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.
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, MacOS 13.7.6, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.7.6, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: reordering cell contents ??
that should work, will have to clean some up that have 3 names...thanks so much.
openoffice 4.1.5 on Windows 10