Thanks:  0
Likes:  0

1. I need a statement that will parse the last eight characters from a text cell

A1= "4B3AG42H31E110359"
=
A2 = "1E110359"

Thanks

2. On 2002-03-05 10:57, mabsher wrote:
I need a statement that will parse the last eight characters from a text cell

A1= "4B3AG42H31E110359"
=
A2 = "1E110359"

Thanks

=RIGHT(A1,8)

Regards,

3. On 2002-03-05 10:57, mabsher wrote:
I need a statement that will parse the last eight characters from a text cell

A1= "4B3AG42H31E110359"
=
A2 = "1E110359"

Thanks

USE
=RIGHT(A1,8)

4. On 2002-03-05 10:59, Barrie Davidson wrote:
On 2002-03-05 10:57, mabsher wrote:
I need a statement that will parse the last eight characters from a text cell

A1= "4B3AG42H31E110359"
=
A2 = "1E110359"

Thanks

=RIGHT(A1,8)

Regards,
Have also a macro for this formule.
I want to do the following:
I put in the numbers in column A from a sheet.
Than by recording the macro,the last two numbers are the indentification for the column.Example:

Colum A

100001
101002
110003

Result after the sorting:

A B C

1000
1010 1100

So I have a 750 numbers in column A which I have to sort on the last two numbers in the column A,B,C,D,E, etc.
Is this possible?
Many thanks.

5. Have also a macro for this formule.
I want to do the following:
I put in the numbers in column A from a sheet.
Than by recording the macro,the last two numbers are the indentification for the column.Example:

Colum A

100001
101002
110003

Result after the sorting:

A B C

1000
1010 1100

So I have a 750 numbers in column A which I have to sort on the last two numbers in the column A,B,C,D,E, etc.
Is this possible?
Many thanks.
I'm sorry, but I don't understand your requirements. Can you clarify what you want to do here please?

Thanks,

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•