Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restricting Characters in a cell.
How would I restrict a column to show only 90 characters; even though you may
have 200 characters downloaded from another dbase? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restricting Characters in a cell.
the first step would be
columns(6).ColumnWidth = 90 Then you would need something in each cell in the adjacent column on the right. -- Regards, Tom Ogilvy "R Bitterman" <R wrote in message ... How would I restrict a column to show only 90 characters; even though you may have 200 characters downloaded from another dbase? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restricting Characters in a cell.
Thanks Tom, but I can only show a maximum of 90 characters of data regardless
of how many characters are downloaded. Our customer then takes the file & downloads the information into their system. An error message comes back if their are more than 90 characters. Ramona "Tom Ogilvy" wrote: the first step would be columns(6).ColumnWidth = 90 Then you would need something in each cell in the adjacent column on the right. -- Regards, Tom Ogilvy "R Bitterman" <R wrote in message ... How would I restrict a column to show only 90 characters; even though you may have 200 characters downloaded from another dbase? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restricting Characters in a cell.
Then you would have to write a macro to remove the excess characters
for each cell in selection if len(cell) 90 then cell.Value = left(cell,90) end if Next -- Regards, Tom Ogilvy "R Bitterman" wrote in message ... Thanks Tom, but I can only show a maximum of 90 characters of data regardless of how many characters are downloaded. Our customer then takes the file & downloads the information into their system. An error message comes back if their are more than 90 characters. Ramona "Tom Ogilvy" wrote: the first step would be columns(6).ColumnWidth = 90 Then you would need something in each cell in the adjacent column on the right. -- Regards, Tom Ogilvy "R Bitterman" <R wrote in message ... How would I restrict a column to show only 90 characters; even though you may have 200 characters downloaded from another dbase? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restricting Number of characters in a cell | Excel Worksheet Functions | |||
Restricting cell selection | Excel Discussion (Misc queries) | |||
Restricting Characters within a User Form | Excel Discussion (Misc queries) | |||
restricting use of certain characters | Excel Discussion (Misc queries) | |||
Restricting Cell Format | Excel Discussion (Misc queries) |