Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing commas
I have a column of data where some data elements have an unwanted comma at
the end (i.e. period,comma,) and some do not (i.e. period,comma). I would like to be able to remove the unwanted comma's at the end (and keep the ones within the data element). Please help. Thanks Ernie |
#2
|
|||
|
|||
Here's one of many ways;
=IF(RIGHT(A1,1)=",",LEFT(A1,LEN(A1)-1),A1) put this in the next column (like b1) then copy down, then copypaste specialvalues to get rid of the formula but keep the results. "Ernie Sersen" wrote in message ... I have a column of data where some data elements have an unwanted comma at the end (i.e. period,comma,) and some do not (i.e. period,comma). I would like to be able to remove the unwanted comma's at the end (and keep the ones within the data element). Please help. Thanks Ernie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing duplicate records in excel, how to do it? | Excel Discussion (Misc queries) | |||
How do I stop excel removing zeros? | Excel Discussion (Misc queries) | |||
Removing ' character from cells | Excel Discussion (Misc queries) | |||
Removing Hidden But Keep Values | Excel Discussion (Misc queries) | |||
When converting an .xls file to .csv I get too many commas at the. | Excel Discussion (Misc queries) |