Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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