selective text
 

Hi i have a text string of 17 characters and I would like to only select the
the first six characters starting on the right hand side eg
MALAC53JJA1234567, i want to display 234567. Hope it can be done ,thanks
--
Eager to learn !

selective text
 

With your text in cell A1 try the below formula

=RIGHT(A1,7)

to convert to a number
=--RIGHT(A1,7)


If this post helps click Yes
---------------
Jacob Skaria


"Graham" wrote:

Hi i have a text string of 17 characters and I would like to only select the
the first six characters starting on the right hand side eg
MALAC53JJA1234567, i want to display 234567. Hope it can be done ,thanks
--
Eager to learn !

selective text
 

Small correction to Jacob's formulas.... the 7's should be a 6's.

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
With your text in cell A1 try the below formula

=RIGHT(A1,7)

to convert to a number
=--RIGHT(A1,7)


If this post helps click Yes
---------------
Jacob Skaria


"Graham" wrote:

Hi i have a text string of 17 characters and I would like to only select
the
the first six characters starting on the right hand side eg
MALAC53JJA1234567, i want to display 234567. Hope it can be done ,thanks
--
Eager to learn !

selective text
 

Thanks Rick..

"Rick Rothstein" wrote:

Small correction to Jacob's formulas.... the 7's should be a 6's.

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
With your text in cell A1 try the below formula

=RIGHT(A1,7)

to convert to a number
=--RIGHT(A1,7)


If this post helps click Yes
---------------
Jacob Skaria


"Graham" wrote:

Hi i have a text string of 17 characters and I would like to only select
the
the first six characters starting on the right hand side eg
MALAC53JJA1234567, i want to display 234567. Hope it can be done ,thanks
--
Eager to learn !