MrsFrankieH
Active Member
- Joined
- Mar 25, 2011
- Messages
- 323
- Office Version
- 365
- Platform
- Windows
Hello fellow Members!
My operating system is Windows 10 and us Office 10.
About 6 years ago, I got help with the problem of separatingdigits. It worked marvelously, however, there was a problem that I hadoverlooked with the formula.
The problem was with single digits. When I used the formulagiven me, single digits would only show up in the first cell, not the secondcell where it belonged. I would like the single digit to show up in the secondcell and a zero ( 0 ) to appear in the first cell, like this….
<ahref="http: mrexcel2_1.jpg.html"target="_blank" media="" fhands="" user="" s213.photobucket.com=""><imgsrc="http: fhands="" alt=" photo MrExcel2_1.jpg" mrexcel2_1.jpg"border="0" cc188="" albums="" i213.photobucket.com=""></imgsrc="http:></ahref="http:>
Any help is appreciated. J
My operating system is Windows 10 and us Office 10.
About 6 years ago, I got help with the problem of separatingdigits. It worked marvelously, however, there was a problem that I hadoverlooked with the formula.
The problem was with single digits. When I used the formulagiven me, single digits would only show up in the first cell, not the secondcell where it belonged. I would like the single digit to show up in the secondcell and a zero ( 0 ) to appear in the first cell, like this….
<ahref="http: mrexcel2_1.jpg.html"target="_blank" media="" fhands="" user="" s213.photobucket.com=""><imgsrc="http: fhands="" alt=" photo MrExcel2_1.jpg" mrexcel2_1.jpg"border="0" cc188="" albums="" i213.photobucket.com=""></imgsrc="http:></ahref="http:>
Any help is appreciated. J