Formula

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

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

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

Hi Kevin,
The formula didn't work. It didn't turn into a function. It shows the
exact thing of =Left(A1,2) instead of the value.
Thank you,
Renee

"Kevin B" wrote:

> 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

Hi Ron,
The formula didn't work. It didn't turn into a function. It shows the
exact thing of =Left(A1,2) instead of the value.
Thank you,
Renee

"Ron Coderre" wrote:

> 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

The cell B1 must have been formatted as text before you typed your
formula in. Use Format | Cells | Number (tab) and select General and
OK. Then double-click in B1 as if to edit the cell then press <enter>.
You should now see the result, and you can copy B1 down the other cells
in column B.

Hope this helps.

Pete

It sounds like the number format for the cell is "text".

Try this:
Select the impacted cells
Format>Cells>Number Tab
Category: Number
Click the [OK] button

Leave those cells selected
Edit>Replace
Find what: =
Replace with: =
Click the [Replace All] button

Does that help?

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

XL2002, WinXP-Pro


"Renee Nguy" wrote:

> Hi Ron,
> The formula didn't work. It didn't turn into a function. It shows the
> exact thing of =Left(A1,2) instead of the value.
> Thank you,
> Renee
>
> "Ron Coderre" wrote:
>
> > 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

Also the function of LEFT() makes the number text, multiply it by 1 to turn it back to a true number.

=LEFT(A1,2)*1

Matt

Not sure that applies here, based on the specs in the original post:

>>A2 015070307 then B2 would show 01
>>A3 04506018 then B3 would show 04


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

XL2002, WinXP-Pro


"Flintstone" wrote:

>
> Also the function of LEFT() makes the number text, multiply it by 1 to
> turn it back to a true number.
>
> =LEFT(A1,2)*1
>
> Matt
>
>
> --
> Flintstone
> ------------------------------------------------------------------------
> Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
> View this thread: http://www.excelforum.com/showthread...hreadid=513757
>
>