ExcelBanter - Removing a digit from a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Removing a digit from a column (https://www.excelbanter.com/excel-discussion-misc-queries/183852-removing-digit-column.html)

pjsmith4321

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?

FSt1

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?

pjsmith4321

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?

All times are GMT +1. The time now is 08:53 PM.