I need to do two things;
first I have string with M which I need to remove like example 2.9M so it should be 2.9.
Second is I have to replace all the space ("-") with zero.
This all I need to do inside an excel.
How to do that?
@Chirag1991 You have to do both things in single string?
not in single string two different strings
To replace - with 0