hi,
if all the data has the same number of characters you can use

=left(a1, 6) where a1 is the cell the data is in and 6 is the number of
characters you want to keep. (change it to the number of characters in your
data.)

if your data is different lengths, you can use
dataTextToColumnsdelimitedcomma

but be careful. text to columns will delete data to the right of the column
you are parsing. if you do have data to the right, copy the column you want
to parse to a blank sheet.

regards

FSt1

"mira" wrote:

I am trying to remove a comma which happens to be the last character in the
cell. Does anyone know how to do this?