Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can excel limit the characters in a cell to 28 automatically?
I have a list of products, about 4000 in all. One of the columns is the
description of the product. Can Excel limit the descriptions to 28 characters by cutting off anything over that number? Please help!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can excel limit the characters in a cell to 28 automatically?
Tom,
Two ways: 1) Use data validation. Slect the column, choose Data / Validation...., choose "Allow" = "Text length", "Data" = "Less than or Equal To", and "Maximum" = 28 2) Use an event: copy the code below, right click on the sheet tab, select view code and paste the code in the window that appears. As written, it will work with column D. HTH, Bernie MS Excel MVP Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 4 Then Exit Sub If Len(Target.Value) 28 Then Application.EnableEvents = False Target.Value = Left(Target.Value, 28) MsgBox "I truncated your entry to 28 characters." Application.EnableEvents = True End If End Sub "Tom" wrote in message ... I have a list of products, about 4000 in all. One of the columns is the description of the product. Can Excel limit the descriptions to 28 characters by cutting off anything over that number? Please help!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel automatically enter the date data in a cell was entered | Excel Worksheet Functions | |||
How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
a way to limit the characters allowed in a cell? | Excel Worksheet Functions | |||
Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) |