Hello,
I want to delete unwanted character or symbol (') form cells in excel.
for example, in a cell I have '54.5 but i want to delete ' and keep 54.5
in fact the problem is that i cant not calculate the average for a column of data due to the presence of that character in the cells. (please look at attachment)
Many thanks