How to arrange number?
Assume that you are having the value in A1 cell like the below:-
A1 cell
0056 4 65
Paste the below formula in B1 cell
=VALUE(SUBSTITUTE(A1," ",""))
Change the cell reference to your desired cell, if required.
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"Sherees" wrote:
Hi
I have a column of around 2000 customer mobile numbers, the numbers are
having space in between nad some numbers entered with two zero in the front.
How can i arrange all the numbers without zero in front and without any space
in between? please guide me with the easiest method
Thank u
--
Life isa journey not a destination
|