hi, how can
how can i convert this 5'2'' value into decimal (5.2) in excel cell? For example, in cell A1 i entered value 5'2'' and in cell B1 i want it as decimal as 5.2. Anyone can help me? Thanks in advance.
hi, how can
how can i convert this 5'2'' value into decimal (5.2) in excel cell? For example, in cell A1 i entered value 5'2'' and in cell B1 i want it as decimal as 5.2. Anyone can help me? Thanks in advance.
How about: 1 Search and Replace the " with blank cell; 2 Search & replace the ' with . (decimal).
1
2
[there were pics of Excel search and replace - that didn't take]