i have a spreadsheet with a list of numbers i need the numbers split in the middle and make 2 columns in the same spreadsheet...


is there an different way other than copy past and cut?

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.

IF all strings have the same length, select the columne, got to the Data ribbon - Text to columns - Fixed width - Next -Place break line where needed - Finish

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post