Thread: [Solved] removing spaces in cell
View Single Post
 
Old 11-06-2016, 05:53 PM
Tonykiwi Tonykiwi is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Oct 2015
Posts: 9
Tonykiwi is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
A simple Find/Replace is sufficient to delete all the spaces and leading 0s, where:
Find = <space>
Replace = <nothing>
perfect thank you. Of interest though, what it the logic that that got rid of the leading zeros?

I'll try to work the next piece out this evening

your help is appreciated
Reply With Quote