Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that just gets the first few numbers in a cell, not all?
I know there's a function or formula in Excel that allows you to just look at
the first or last few numbers in a particular cell. Ex.I need my if then formula to just look at the first 5 numbers in a cell (the zip code) and ignore the -3645 behind the zip code. help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that just gets the first few numbers in a cell, not all?
=left(a1, 5)
There is also right and mid to manipulate text. Note that these functions return text, so if you need to get the numbe rback youwill need to use the value funtion... -- HTH... Jim Thomlinson "KenCanuck" wrote: I know there's a function or formula in Excel that allows you to just look at the first or last few numbers in a particular cell. Ex.I need my if then formula to just look at the first 5 numbers in a cell (the zip code) and ignore the -3645 behind the zip code. help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that just gets the first few numbers in a cell, not all?
First few LEFT, last few RIGHT
-- David Biddulph "KenCanuck" wrote in message ... I know there's a function or formula in Excel that allows you to just look at the first or last few numbers in a particular cell. Ex.I need my if then formula to just look at the first 5 numbers in a cell (the zip code) and ignore the -3645 behind the zip code. help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that just gets the first few numbers in a cell, not all?
=LEFT(A1,5)
or =MID(A1,1,5) two formula above are return text value not real Excel value. To covert text value to real Excel value you can use one of these formula. =--LEFT(A1,5) =LEFT(A1,5)+0 =LEFT(A1,5)*1 =LEFT(A1,5)^1 =VALUE(LEFT(A1,5)) =LEFT(A1,5)/1 =LEFT(A1,5)-0 Samething for MID function "KenCanuck" wrote: I know there's a function or formula in Excel that allows you to just look at the first or last few numbers in a particular cell. Ex.I need my if then formula to just look at the first 5 numbers in a cell (the zip code) and ignore the -3645 behind the zip code. help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for automatic up on numbers in cell in exel | Excel Worksheet Functions | |||
formula for pulling only numbers but not text from another cell | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) |