Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting Cells
Hello,
I am currently using Office 2003 - OS - Windows XP I was just approaches with a question pertaining to Excel and thought I would also direct to you because at this point I am unsure of the answer. Is it possible to automatically make a cell have 10 spaces and nothing else? For example, if you input a students name with only 6 letters, Excel will automatically add 4 spaces after their name. Also, if the students name has 11 characters, it will only allow 10 characters to be inputted. Thanks in Advance. |
#2
|
|||
|
|||
Hi,
If the names are in column A starting at A1, create a helper column (say B) with the following formula in B1 and drag the formula down Column B. =left(A1&" ",10) There should be 9 spaces between the quotation marks, so that the formula would correctly interpret even a single letter name (!). It will not hurt if you enclose more spaces between the "-marks. Regards. B. R. Ramachandran "Christy" wrote: Hello, I am currently using Office 2003 - OS - Windows XP I was just approaches with a question pertaining to Excel and thought I would also direct to you because at this point I am unsure of the answer. Is it possible to automatically make a cell have 10 spaces and nothing else? For example, if you input a students name with only 6 letters, Excel will automatically add 4 spaces after their name. Also, if the students name has 11 characters, it will only allow 10 characters to be inputted. Thanks in Advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Discussion (Misc queries) |