| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
three digits
I have some cells that have five digits, I want to take only the first three
digits. pleas can you help me? -- MFS22 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
three digits
A1 = 5 digit number
=value(LEFT(A1,3)) If this post helps click Yes --------------- Jacob Skaria "MFS" wrote: I have some cells that have five digits, I want to take only the first three digits. pleas can you help me? -- MFS22 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
three digits
try,
=left(a1,3) mike "MFS" wrote: I have some cells that have five digits, I want to take only the first three digits. pleas can you help me? -- MFS22 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
three digits
Hi MFS,
You can use following function, assuming you have the data in cell A1:- =VALUE(MID(A1,1,3)) Note: - In the formula, you can increast "3" to get more and less numbers picking up. Thanks. -- Click on Yes, if it is useful. Thanks & Best Regards, Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) New Delhi, India "MFS" wrote: I have some cells that have five digits, I want to take only the first three digits. pleas can you help me? -- MFS22 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| last 2 digits | Excel Discussion (Misc queries) | |||
| last ten digits | Excel Worksheet Functions | |||
| 2 DIGITS OUT OF 4 | Excel Discussion (Misc queries) | |||
| 2 DIGITS OUT OF 4 | Excel Discussion (Misc queries) | |||
Linear Mode
