Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default set a maximum of characters allowed in a cell

Hello,

Does anybody know how i can set a maximun of characters allowed in one cell.
I need to copy an excel sheet into a database of another program,
but this program has limited characters in his fields.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default set a maximum of characters allowed in a cell

Data/ Validation/ Formula something like =LEN(A2)<=6
--
David Biddulph

"Huisman" wrote in message
...
Hello,

Does anybody know how i can set a maximun of characters allowed in one
cell.
I need to copy an excel sheet into a database of another program,
but this program has limited characters in his fields.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum amount allowed Wannano Excel Discussion (Misc queries) 1 March 13th 07 07:25 PM
changing maximum characters allowed in excel cells slipman Excel Discussion (Misc queries) 2 March 9th 07 11:34 PM
Maximum Characters in a cell CharlieS Excel Discussion (Misc queries) 1 September 1st 06 08:34 PM
Which the maximum of characters of value in a cell? Malisky Excel Discussion (Misc queries) 1 January 12th 06 01:33 PM
a way to limit the characters allowed in a cell? EmRit24 Excel Worksheet Functions 3 April 29th 05 09:30 PM


All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"