Thread
:
Formula Please?
View Single Post
#
10
Posted to microsoft.public.excel.misc
Saxman
external usenet poster
Posts: 111
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.
Reply With Quote
Saxman
View Public Profile
Find all posts by Saxman