Formula Please?
Thanks for the feed-back.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Saxman" wrote in message
...
RagDyeR wrote:
If they're *always* single digits,
They are.
Extract the first 4 with:
=Left(A1)
And the second 4 with:
=Left(Right(A1,2))
Both work fine.
Thanks again.
|