Limiting The Amount of Text

  • Thread starter Thread starter hk1997
  • Start date Start date
H

hk1997

Hi,
Is there a way I can limit the amount of Text I can enter into th
cells of a selected column?

For example, when listing on eBay, the description bar on eBay i
limited to 40 characters. Since I list items on eBay with Excel, i
would save me a lot of time if I were able to lock the cells in m
"Description" column to 40 characters instead of going back an
counting all the characters in those cells.

Is this doable
 
There may be a non-code way to limit the # of characters, but i don't know
it. Maybe someone else will contribute.

An easy, alternate solution that may work for you is to let Excel do some of
the counting for you via Conditional Formatting:
-Select the Column
-Format>ConditionalFormatting
-FormulaIs "= Len(C1)>40". (Replace C1 with the first cell in your column
and don't type the quotes)
-Select your formatting (Red text, Red fill, whatever).

That way any cell that has more than 40 characters will call attention to
itself. Edit the cell. Once your edits reduce the character count below 41
the cell will appear normal.

Hope this helps,
 
Replying to myself:

Sorry, I was having an idiot moment in my first response. You can use
Data/Validation to physically limit the number of characters allowed to be
input in a given cell.

Personally, I'd find ConditionalFormatting less annoying to work with in
this case, but maybe that's me.

--
George Nicholson

Remove 'Junk' from return address.


George Nicholson said:
There may be a non-code way to limit the # of characters, but i don't know
it. Maybe someone else will contribute.

An easy, alternate solution that may work for you is to let Excel do some of
the counting for you via Conditional Formatting:
-Select the Column
-Format>ConditionalFormatting
-FormulaIs "= Len(C1)>40". (Replace C1 with the first cell in your column
and don't type the quotes)
-Select your formatting (Red text, Red fill, whatever).

That way any cell that has more than 40 characters will call attention to
itself. Edit the cell. Once your edits reduce the character count below 41
the cell will appear normal.

Hope this helps,
Click to expand...
 
Back
Top