| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula to standarize cell length
I have a spread sheet with data in Column A. Some of the cells have 3
characters, some have 6, some have 8, and some have 10. I would like to standardize the length of each cell to 10 characters. Is there a formula that will do this? I could write a macro to do it but the requirments are for a formula if it is possible. Thanks for the help -- JT |
|
#2
|
|||
|
|||
|
Do you want max characters 10 in a cell? if so look at datavalidation and
text lenght and less than or equal to 10 Regards, Peo Sjoblom "JT" wrote: I have a spread sheet with data in Column A. Some of the cells have 3 characters, some have 6, some have 8, and some have 10. I would like to standardize the length of each cell to 10 characters. Is there a formula that will do this? I could write a macro to do it but the requirments are for a formula if it is possible. Thanks for the help -- JT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| looking for a formula | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions | |||
| Conditional Formatting for dates | Excel Worksheet Functions | |||
Linear Mode
