Duplicate words in cells (or how to split cell in exactly half)

		Microsoft Office Forums > Microsoft Excel > Excel
Duplicate words in cells (or how to split cell in exactly half)

FAQ

Thread Tools

Display Modes

04-20-2018, 11:37 AM

ballpoint

Windows 10 Duplicate words in cells (or how to split cell in exactly half)

Office 2016

Advanced Beginner

Join Date: Sep 2017

Posts: 40

Duplicate words in cells (or how to split cell in exactly half)

I made some minor mistake in collecting data and what happens now is that I have a beautiful excel file with a column reading something like this:

Code:

Alice and BobAlice and Bob
Roger and CharlesRoger and Charles

I need to remove the extra information, but I have not been able to find a way to do so. Clearly, It is not possible to use text to column, but I thought there must be a way to fix this. Any tip? (Please! It's 13,000 rows!)

Thanks!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Split data in cells and duplicate rows	ballpoint	Excel Programming	6	02-07-2018 05:52 PM
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell?	jsisley	Excel	1	07-21-2017 09:20 AM
how can i split a column of rows in half without copy and paste..	Lindseyfparker	Excel	2	04-25-2014 12:52 AM
How do I see one document map for each half of a split MS WORD 2010 document?	quickwin	Word	3	07-09-2013 10:20 PM
Words & letters half burried in a Text field in a table.	Ed54	Word	4	01-05-2012 04:10 PM