Parse data

[mabsher]

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

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

Thanks

 

[Barrie Davidson]

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,

 

[IML]

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)

 

[Guest]

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.

 

[Barrie Davidson]

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,