Text to Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allan Fischler - 08 Oct 2007 18:40 GMT

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.

Reply to this Message

Gordon - 08 Oct 2007 18:45 GMT

>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
[quoted text clipped - 15 lines]
>
> Thanks.

You need the "RIGHT" function....

Reply to this Message

Pete_UK - 08 Oct 2007 19:23 GMT

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

> 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
[quoted text clipped - 13 lines]
>
> Thanks.

Reply to this Message

Joanne - 08 Oct 2007 14:55 GMT

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

> Try this:
>
[quoted text clipped - 25 lines]
> >
> > Thanks.

Reply to this Message

Pete_UK - 09 Oct 2007 09:13 GMT

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

Pete

> Thanks a bunch Pete
> I appreciate your time and efforts on my behalf
[quoted text clipped - 30 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: