ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Removing last character in a cell (https://www.excelbanter.com/excel-worksheet-functions/120928-re-removing-last-character-cell.html)

John Bundy

Removing last character in a cell
 
Change G11 to the cell you need changed or to your program.

=MID(G11,1,(LEN(G11)-1))

"Megadrone" wrote:

I need to remove the last character in a cell.

Example:

121,123,124,
184,124,145,167,

I need to remove the last comma only. The cells contains varying amounts of
data. none of the commands I have found will do this.



All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com