| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a left pad formula method
(you may have to format both columns as text)
Just to add then: You don't need to format either column as text. the results will be text irrespective of formatting. -- Regards, Tom Ogilvy "OJ" wrote in message oups.com... Hi, Assuming the originals are in Column A and you want the padded version in column B this should work (you may have to format both columns as text) =REPT("0",10-LEN(A1))&A1 HTH, OJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Method 'Left' of object 'DataLabel' failed | Charts and Charting in Excel | |||
| Please post this thread a correct full method, method about | New Users to Excel | |||
| Please post this thread a complete correct method, method about te | New Users to Excel | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
| formula or method needed | Excel Programming | |||
Threaded Mode
