Formula

R

Renee Nguy

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
 
K

Kevin B

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.
 
R

Ron Coderre

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
 
R

Renee Nguy

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
 
R

Renee Nguy

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
 
P

Pete_UK

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
 
R

Ron Coderre

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
 
F

Flintstone

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
 
R

Ron Coderre

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


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

XL2002, WinXP-Pro
 
Top