Thread: Duplicate words in cells (or how to split cell in exactly half)
View Single Post
 
Old 04-20-2018, 12:22 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
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)
Reply With Quote