extract last 2 characters from the right?
 

Need to obtain in one cell the 2 right most characters from another
cell. Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre

extract last 2 characters from the right?
 

Hi Pierre

Try this:

=MID(A1,LEN(A1)-1,2)

Regards
Per

"Pierre" skrev i meddelelsen
...
Need to obtain in one cell the 2 right most characters from another
cell. Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre

extract last 2 characters from the right?
 

Per, thanks for the reply. . .that soultion returns "TRUE".
Looking for the last 2 characters.

Got a plan B?

Thanks.

Pierre


On Dec 21, 2:50*pm, "Per Jessen" wrote:
Hi Pierre

Try this:

=MID(A1,LEN(A1)-1,2)

Regards
Per

"Pierre" skrev i ...



Need to obtain in one cell the 2 right most characters from another
cell. *Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre- Hide quoted text -

- Show quoted text -

extract last 2 characters from the right?
 

=RIGHT(A1,2)
--
David Biddulph

"Pierre" wrote in message
...
Need to obtain in one cell the 2 right most characters from another
cell. Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre

extract last 2 characters from the right?
 

Have you looked in the help index for RIGHT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pierre" wrote in message
...
Need to obtain in one cell the 2 right most characters from another
cell. Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre

extract last 2 characters from the right?
 

On Dec 21, 3:04*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=RIGHT(A1,2)
--
David Biddulph

"Pierre" wrote in message

...



Need to obtain in one cell the 2 right most characters from another
cell. *Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre- Hide quoted text -

- Show quoted text -

Too cool!!

Thank you.

Pierre

extract last 2 characters from the right?
 

=right(a1,2)
--
hope to help,
cm


"Pierre" wrote:

Need to obtain in one cell the 2 right most characters from another
cell. Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre
.

extract last 2 characters from the right?
 

btw, Per's did work.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pierre" wrote in message
...
On Dec 21, 3:04 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=RIGHT(A1,2)
--
David Biddulph

"Pierre" wrote in message

...



Need to obtain in one cell the 2 right most characters from another
cell. Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre- Hide quoted text -

- Show quoted text -

Too cool!!

Thank you.

Pierre

extract last 2 characters from the right?
 

On Dec 21, 3:26*pm, "Don Guillett" wrote:
btw, Per's did work.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Pierre" wrote in message


I agree. It started working after a few minutes, when I adjusted a
cell reference. Sorry about the erronious post.
Thank you Don, and Per.

Pierre