convert of 5'2'' into 5.2 in excel cell

1

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.

Answer
Discuss

Answers

0

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]

Discuss

Discussion

Sorry photos are currently not allowed. It is a feature I can look to add in the future, though.
don (rep: 1322) May 9, '17 at 11:29 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login