How do I limit characters in a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell with this information: "1234_01_251225". I need to have a
formula that will only give me the first 4 characters "1234". Is there a way
to do this? I need to add the formula to the entire column of data, since I
have thousands of rows of data.
 
Data>Validation, Settings Tab.
In the Allow field, choose Text Length.
In the Data field, choose which option you want (but I would recommend
keeping it set to the default of "between").
With "between" as the Data option, enter a number in the Minimum field
(probably 0 in your case) and then the limit you want in the Maximum
field.
Copy that cell to as many other cells in the worksheet where you want
this limitation.

Now, users will not be able to enter more characters in the cell(s)
than the limit you set.

Hope this helps - let me know.
 
I need to do basically the same thing -- allow folks to enter data over the
limit, but truncate it to the limit upon exiting cell -- but when I try this
formula in the cell where the data is entered, I get a circular reference
error.
 
Have your formulas in adjacent cells in a helper column.

Column A is where you enter the data.

Column B is where you have the formula.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Limitation on MID function? - very large string 4
vlookup character limitations 1
Look up a text value then count records < a date 3
Help with time function 4
Deleting LF Characters in cells 9
Multiple Numbers in a cell 3
Count Unique with criteria condition 1

Back
Top