Hello
Could you please help me? I have tons and tons of numbers written in this format
65.143.42
but i need them to be written like this (without dots)
6514342
Could you please help me? I apologize for busting in like this.
Thank you
Liam
Hello
Could you please help me? I have tons and tons of numbers written in this format
65.143.42
but i need them to be written like this (without dots)
6514342
Could you please help me? I apologize for busting in like this.
Thank you
Liam
If 65.143.42 is in cell A1 then...
=SUBSTITUTE(A1,".","")
or select the entire cells
Press Ctrl+H
Enter . dot in find what place
leave Replace with as blank
and click on replace all
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks