Thread: Formula Please?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Saxman Saxman is offline
external usenet poster
 
Posts: 111
Default Formula Please?

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.