| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing a digit from a column
I have a column of data that I need to remove the last digit in each cell.
Is there a formula for doing so, so that I don't have to use find and replace? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing a digit from a column
hi
try this =LEFT(F3,LEN(F3)-1) adjust cell address to suit. copy down. regards FSt1 "pjsmith4321" wrote: I have a column of data that I need to remove the last digit in each cell. Is there a formula for doing so, so that I don't have to use find and replace? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing a digit from a column
Thanks. Worked perfectly.
PJS "FSt1" wrote: hi try this =LEFT(F3,LEN(F3)-1) adjust cell address to suit. copy down. regards FSt1 "pjsmith4321" wrote: I have a column of data that I need to remove the last digit in each cell. Is there a formula for doing so, so that I don't have to use find and replace? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Info from Column A and Removing it from Column B | Excel Discussion (Misc queries) | |||
| Removing a check digit | Excel Discussion (Misc queries) | |||
| How do I insert the same extra digit to each cell in a column? | Excel Discussion (Misc queries) | |||
| removing digit or calc LEN fields | Excel Worksheet Functions | |||
| In Excel, how do I sort a column by the LAST digit of the data? | Excel Discussion (Misc queries) | |||
Linear Mode
