Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force line break based on text
I am writing several large Excel worksheets where one column has to be
limited to 74 characters per cell spread over two lines i.e. maximum of 37 per line. Is there a way to automatically force a line break after the 37th character and also restrict the text in the cell to a maximum of 74 characters. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force line break based on text
Hi
Select the column, goto Data Validation Allow : Text length Data: "Less than or equal to" Maximum : 74 Ok Format Format cells Alignment Check Wrap text Adjust the column with to hold 37 chacters. Regards, Per "Quizologist" skrev i meddelelsen ... I am writing several large Excel worksheets where one column has to be limited to 74 characters per cell spread over two lines i.e. maximum of 37 per line. Is there a way to automatically force a line break after the 37th character and also restrict the text in the cell to a maximum of 74 characters. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force line break based on text
Hi
Thanks for reply, I have tried most of what you suggested before but my problem comes with your last instruction - How do I adjust the column width to limit it to 37 characters? I cannot find any way to do this. Scott "Per Jessen" wrote: Hi Select the column, goto Data Validation Allow : Text length Data: "Less than or equal to" Maximum : 74 Ok Format Format cells Alignment Check Wrap text Adjust the column with to hold 37 chacters. Regards, Per "Quizologist" skrev i meddelelsen ... I am writing several large Excel worksheets where one column has to be limited to 74 characters per cell spread over two lines i.e. maximum of 37 per line. Is there a way to automatically force a line break after the 37th character and also restrict the text in the cell to a maximum of 74 characters. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force line break based on text
I have just realised my mistake, i know have it working thank you for your
help. Scott "Quizologist" wrote: Hi Thanks for reply, I have tried most of what you suggested before but my problem comes with your last instruction - How do I adjust the column width to limit it to 37 characters? I cannot find any way to do this. Scott "Per Jessen" wrote: Hi Select the column, goto Data Validation Allow : Text length Data: "Less than or equal to" Maximum : 74 Ok Format Format cells Alignment Check Wrap text Adjust the column with to hold 37 chacters. Regards, Per "Quizologist" skrev i meddelelsen ... I am writing several large Excel worksheets where one column has to be limited to 74 characters per cell spread over two lines i.e. maximum of 37 per line. Is there a way to automatically force a line break after the 37th character and also restrict the text in the cell to a maximum of 74 characters. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you force a new line in a formula in Excel? | Excel Worksheet Functions | |||
How do I insert a line break (carriage return) in text in a cell? | Excel Discussion (Misc queries) | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
Force Page Break | Excel Discussion (Misc queries) | |||
concatenate, force new line | Excel Worksheet Functions |