Search results

Is it possible to make microsoft excel automatically display a number in written? What i mean is if i have a cell say C2 having value as 76 can i somehow make it display as Seventy Six.

Thanks Vijay, this helps to an extent. What if some cells have special characters like ! or -, lets say it should check for any special character and then remove it. do i add substitute for every character i will be trying that for now but there will defiantly be an alternate way :)

Hi There, I am quite a fresher in excel, how do i remove special characters and spaces from a cell: example of my data in a column (B) ver2.3 aabc.doc ver2.0 aaebc.xls ver1.1 adfhadf.doc and so on there are like 2000 entries please help