| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
each cell have same number of charaters
I need to ensure each cell has 8 characters throughout a column .
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
each cell have same number of charaters
If we already have data in column A, then in B1 enter:
=IF(LEN(A1)=8,"","bad length") and copy down. This will reveal bad items If data is being entered into column A, then just use Data Validation: Data... Validation... Custom Formula =len(A1)=8 -- Gary''s Student - gsnu201002 "htown" wrote: I need to ensure each cell has 8 characters throughout a column . |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
each cell have same number of charaters
You are very UN clear about your need so I'll guess it's numbers and you want to custom format 00000000 -- Don Guillett Microsoft MVP Excel SalesAid Software "htown" wrote in message ... I need to ensure each cell has 8 characters throughout a column . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove slash charaters from a date field | Excel Discussion (Misc queries) | |||
| Click = Random Charaters Into A Cell | Excel Worksheet Functions | |||
| How do I remove non-numerical charaters from a string? | Excel Worksheet Functions | |||
| Counting Charaters | Excel Worksheet Functions | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
Linear Mode
