Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
left padding + blank
Hello,
Is it possible to left pad a cell, but only if it's not blank ? eg, 600 = 00600 50000 = 50000 [blank] = [blank] (I've just succeeded for non-blank cells) Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wrap text inserts a padding blank line | New Users to Excel | |||
Autofill Down When Text to Left is Not Blank | Excel Worksheet Functions | |||
Validating cells left blank | Excel Programming | |||
counting from left to right and stopping when blank | Excel Discussion (Misc queries) |