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, 12:22 PM

NoSparks

Windows 7 64bit Duplicate words in cells (or how to split cell in exactly half)

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

You won't be able to do that in the original cell without using VBA, but
you can get what you want in another column using a formula
=LEFT(A2,LEN(A2)/2)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 PM.