How to find data character width in Excel
In Excel, is there a way to find out the character width of the data in a
column? I have a column with 60,000 records and each record contains Street names. I want to know what is the longest possible street name. I also want to look at the distribution of the character or pixel width of all the street names. Similarly, I have about 100 other columns with 60,000 records which contain varying length of text, numeric or memo field data and again I want to find the character width edge cases and distribution. The end goal is to give guidance to UI design folks on mean and edge case character width so they can decide on column width and word wrap. Excel functions work with the data itself while I am interested in the width of the data. Any idea how one could possibly do this in Excel? If its possible in Visual Basic, can you provide step by step directions since I am a novice in programming. Thanks! |
How to find data character width in Excel
I found it... Its LEN(fieldname) :-))))))))))))))
"ToExcelAtExcel" wrote: In Excel, is there a way to find out the character width of the data in a column? I have a column with 60,000 records and each record contains Street names. I want to know what is the longest possible street name. I also want to look at the distribution of the character or pixel width of all the street names. Similarly, I have about 100 other columns with 60,000 records which contain varying length of text, numeric or memo field data and again I want to find the character width edge cases and distribution. The end goal is to give guidance to UI design folks on mean and edge case character width so they can decide on column width and word wrap. Excel functions work with the data itself while I am interested in the width of the data. Any idea how one could possibly do this in Excel? If its possible in Visual Basic, can you provide step by step directions since I am a novice in programming. Thanks! |
How to find data character width in Excel
Not sure if I'm answering the question that you are asking but ...
To get the maximum length of the data in, say, column Q, array enter the formula: {=MAX(LEN(Q2:Q60000))} (use Ctrl-Shift-Enter rather than just Enter) Not a clue what to say about the rest of the question. Regards Trevor "ToExcelAtExcel" wrote in message ... In Excel, is there a way to find out the character width of the data in a column? I have a column with 60,000 records and each record contains Street names. I want to know what is the longest possible street name. I also want to look at the distribution of the character or pixel width of all the street names. Similarly, I have about 100 other columns with 60,000 records which contain varying length of text, numeric or memo field data and again I want to find the character width edge cases and distribution. The end goal is to give guidance to UI design folks on mean and edge case character width so they can decide on column width and word wrap. Excel functions work with the data itself while I am interested in the width of the data. Any idea how one could possibly do this in Excel? If its possible in Visual Basic, can you provide step by step directions since I am a novice in programming. Thanks! |
All times are GMT +1. The time now is 09:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com