Thread: how can i split a column of rows in half without copy and paste..
View Single Post
 
Old 04-24-2014, 10:23 PM
jolivanes jolivanes is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default
If you have the numbers in Column A, put this formula in the same row in Column B
=LEFT(C3,LEN(C3)/2)
and this formula in the same row in Column C
=RIGHT(C3, LEN(C3)-LEN(D3))
If you have an odd amount of numbers, it'll give you a rounddown in Column B and a roundup in Column C.
Last edited by jolivanes; 04-24-2014 at 10:24 PM. Reason: delete apostrophe
Reply With Quote