Splitting up text in Excel row

  • Thread starter Thread starter GISGuy
  • Start date Start date
G

GISGuy

In my spreadsheet, I have rows that contain 510 characters. The colum
name is "Fileout" I would like to have 2 more columns (Fileout1
Fileout2) where the first 255 characters go into "Fileout1" and th
last 255 characters go into "Fileout2"

Using Excel 200
 
Say your current column is Column A starting in A1. In B1 enter:
=Left(A1,255)
In C1 enter:
=Right(A1,255)
Copy these formulas all the way down as far as your data goes.
At that point both B and C columns contain formulas. You probably want to
eliminate the formulas and have just the values. Do this:
Select all filled cells in Columns B & C. Do Edit - Copy.
Select B1.
Do Edit - PasteSpecial and select Values. Click OK

If, by any chance, you don't have exactly 510 characters in each and every
cell of Column A, and you want 255 in Column B and the rest in Column C,
then enter the following in C1 instead of the above = Right formula:
=MID(A1,256,LEN(A1)-255)

HTH Otto
 
Back
Top