Text to Columns

[Joanne]

Thanks a bunch Pete
I appreciate your time and efforts on my behalf
Pete_UK wrote:

 

[Allan Fischler]

I have a column and all I need is the last 5 characters in this field.
Problem is that this field has various text lengths. How can I get the last
5 characters and delete the rest. My spreadsheet have 1,000 or so lines.

This Column looks like this:

AESGROUPGR123
AESGROUPGR457
AESGROUPGR236
SECTIOGR046
MSGTYHSYHSYHGR123
MSGTYHSYYHGR123

My first thought was to make ths column flush right in Text to columns, but
I do not see that making it flush right is an option. Ideas?

Thanks.

 

[Gordon]

I have a column and all I need is the last 5 characters in this field.
Problem is that this field has various text lengths. How can I get the
last
5 characters and delete the rest. My spreadsheet have 1,000 or so lines.

This Column looks like this:

AESGROUPGR123
AESGROUPGR457
AESGROUPGR236
SECTIOGR046
MSGTYHSYHSYHGR123
MSGTYHSYYHGR123

My first thought was to make ths column flush right in Text to columns,
but
I do not see that making it flush right is an option. Ideas?

Thanks.

You need the "RIGHT" function....

 

[Pete_UK]

Try this:

=RIGHT(A1,5)

and copy down, assuming your data is in column A. Fix the values
using <copy> with Edit | Paste Special, then you can get rid of your
original data.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Joanne - thanks for feeding back.

Pete