Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default Formula

The left() formula will do it.

In column B row 1 place the following formula:

=Left(A1,2)

Then copy it down column B as far as necessary.
--
Kevin Backmann


"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