Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Column width
Good day,
I am recieving a spreedsheet that is set up programmatically in Germany and the columns are set to certain widths and this is causing problems when doing a count for names in the column. The column is set to 30 characters and Text; if i have the name "Nel" with a look up it does not see it as i do not have the spaces ? If i use the name "Nel" & "27 spaces" then it finds it ? Could i please have some advise on how to rectify this as i have names varying in lenght. Thanks Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Column width
Hi Tempy,
You could trim them all For Each cell In ActiveSheet.UsedRange If Not cell.HasFormula Then cell.Value = Trim(cell.Value) End If Next cell -- HTH RP (remove nothere from the email address if mailing direct) "Tempy" wrote in message ... Good day, I am recieving a spreedsheet that is set up programmatically in Germany and the columns are set to certain widths and this is causing problems when doing a count for names in the column. The column is set to 30 characters and Text; if i have the name "Nel" with a look up it does not see it as i do not have the spaces ? If i use the name "Nel" & "27 spaces" then it finds it ? Could i please have some advise on how to rectify this as i have names varying in lenght. Thanks Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Column width
Thanks Bob,
Works great, i only did the required columns though as the spreedsheet is too big. Tempy *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |