Excel SUBSTITUTE Function Tips

Using Substitute Function To Convert Values With Comma To Numbers

We encounter this problem of numbers behaving as text with commas when we import data from some other software in to excel sheet. 

Can You Convert A Number Present As String To A Proper Number?

There are times when you bring data from other software to excel sheets and find that some of the numbers are formatted as text