Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Microsoft Excel 2002
How to specify cell length with text and leading spaces?
I want a cell to have only 35 text characters; however, I want the text I enter to be counted with leading blank spaces. Similar to the leading 0 function that can be configured in the Format Cell, Number, Custom to mandate 4 number spaces where the number 12 is entered into the cell however with 4 number spaces (e.g. 0000) what will show up in the cell is 0012. In the Format Cell, Number, Custom the " "@ does not include the text after the @ in the total count rather this function ADDS text entered into the cell after the @ so if count between the quotes" " is 35 the text entered into the cell (e.g. gate) the total characters in the cell is 39. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Microsoft Excel 2002
Use Data Validation Custom Formula is:
=len(B9)<36 for cell B9 -- Gary''s Student - gsnu200747 "Sharon" wrote: How to specify cell length with text and leading spaces? I want a cell to have only 35 text characters; however, I want the text I enter to be counted with leading blank spaces. Similar to the leading 0 function that can be configured in the Format Cell, Number, Custom to mandate 4 number spaces where the number 12 is entered into the cell however with 4 number spaces (e.g. 0000) what will show up in the cell is 0012. In the Format Cell, Number, Custom the " "@ does not include the text after the @ in the total count rather this function ADDS text entered into the cell after the @ so if count between the quotes" " is 35 the text entered into the cell (e.g. gate) the total characters in the cell is 39. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Microsoft Query is lost when opening Excel 2002 file | Excel Discussion (Misc queries) | |||
microsoft woord 2002 | Excel Discussion (Misc queries) | |||
Microsoft Office 2002 Excel sheets | Excel Discussion (Misc queries) | |||
Problem accessing Oracle Public Synonyms from Microsoft Excel 2002 | Excel Discussion (Misc queries) |