Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing last character in a cell
Insert a Helper Column next to your data. In that column, enter the formula:
=LEFT(A1,LEN(A1)-1) Copy the formula down the Helper Column as far as needed. The Helper Column should now contain the data you want. Now, to replace the original data, copy the Helper Column. Then select the original column, and PASTE SPECIAL. Select "Values". You can then delete the Helper Column. HTH, Elkar "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |