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

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

Formula
 

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

Formula
 

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

Formula
 

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

Formula
 

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

Formula
 

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

Try this:
Select the impacted cells
FormatCellsNumber Tab
Category: Number
Click the [OK] button

Leave those cells selected
EditReplace
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

Formula
 

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

Formula
 

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