One More Excel Question

[Fiveohhh]

Is it possible to just take the last to letters off every column and move them to the next column?

 

[AmerDoux]

Highlight the cell(s) you want to do this with.
Go to Data/Text to Columns
Choose Fixed Width
and click where ever you want the break to occur

g/l

 

[Transition]

Originally posted by: Fiveohhh
Is it possible to just take the last to letters off every column and move them to the next column?

=RIGHT(A1,2)

Example..

Cell A1 Contains the Following:
I LOVE TO NEF

And if cell A2 contains the formula =RIGHT(A1,2), the result should be
EF

 

[joshg]

Originally posted by: Transition

Originally posted by: Fiveohhh
Is it possible to just take the last to letters off every column and move them to the next column?

=RIGHT(A1,2)

Example..

Cell A1 Contains the Following:
I LOVE TO NEF

And if cell A2 contains the formula =RIGHT(A1,2), the result should be
EF

And, if you do it like this, to get the first part of the cell, you'd have a formula that says:

=LEFT(A1,LEN(A1)-2)

.. Which would return "I LOVE TO N"