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 !
|