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 

More Majid Amani Beni's questions See All
Similar questions and discussions