Dividing columns in Excel

  • Thread starter Thread starter Marcelo
  • Start date Start date
M

Marcelo

I have a large excel file, about 18000 rows, I would like
to divide one column in two, one with 26 character, one
with 20 character, there is any way I can do this with out
braking words in the division.

Thanks,

Marcelo
 
Some additional information and a simple example would be helpful.

The only interpretation I have for your words has nothing to do with
charting, so I suspect that I have completely misunderstood.

If you are wanting to know how to break a text string into two
substrings, see Help for LEFT(), MID(), and RIGHT(), such as
=LEFT(A1,26)
=RIGHT(A1,20) or =MID(A1,27,LEN(A1))

If you further want to break at a space rather than a set position, see
Help for FIND(). Without knowing which column you want to increase when
26/20 breaks in mid-word, I can't suggest a specific formula.

Jerry
 
Back
Top