For a value in A1
B1: =LEFT(A1,2)
copy that formula down as far as you need.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Renee Nguy" wrote:

This is what I currently have:
A1 18506352, I would like B1 to pick up the first two digits so B1 would 18
A2 015070307 then B2 would show 01
A3 04506018 then B3 would show 04
Please help me create this formula
Thank you so much.
Renee