![]() |
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