Thread: Formula Please?
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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.