Anybody good with Excel? I have a data validation question - GoFuckYourself.com

Juicy D. Links · 01-25-2007, 08:33 PM

yo

i dont want the field to have more than 55 characters.

my xls file has already 6000 lines of data , i want to limit and format exisitng data in a column so that it dont exceed 55 characters.

how i do this?

BTW: i just pleasured myself

rowan · 01-25-2007, 08:35 PM

GFY has no problem validating your 11 duplicate posts

Spunky · 01-25-2007, 08:37 PM

Post Bot Alert!!!!!!!!!!!!

niche25 · 01-25-2007, 08:44 PM

Quote:

Originally Posted by Juicy D. Links

i dont want the field to have more than 55 characters.

X 11? lol.

AsianDivaGirlsWebDude · 01-25-2007, 08:52 PM

When you are doing your set-up, in the menu bar select Data, then Validation. In the pop-up, under the Settings tab, you can set the type of characters (validation criteria), and minimum/maximum number of characters.

ADG Webmaster

Juicy D. Links · 01-25-2007, 08:53 PM

Quote:

Originally Posted by AsianDivaGirlsWebDude

When you are doing your set-up, in the menu bar select Data, then Validation. In the pop-up, under the Settings tab, you can set the type of characters (validation criteria), and minimum/maximum number of characters.

ADG Webmaster

kk let me try that thx

AsianDivaGirlsWebDude · 01-25-2007, 09:00 PM

Quote:

Originally Posted by Juicy D. Links

kk let me try that thx

Depending on your OS and version, it might be slightly different - if so, go to the Excel Help section and type a few of the key words I listed, and you should find the solution.

ADG Webmaster

01-25-2007, 08:33 PM	#1
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	Anybody good with Excel? I have a data validation question yo i dont want the field to have more than 55 characters. my xls file has already 6000 lines of data , i want to limit and format exisitng data in a column so that it dont exceed 55 characters. how i do this? BTW: i just pleasured myself

01-25-2007, 08:37 PM	#3
Spunky I need a beer Industry Role: Join Date: Jun 2002 Location: ♠ Toiletville ♠ Posts: 133,939	Post Bot Alert!!!!!!!!!!!! __________________ *YOUR INFORMATION HERE*

01-25-2007, 08:52 PM	#5
AsianDivaGirlsWebDude Purveyor, Fine Asian Porn Industry Role: Join Date: Jul 2004 Location: San Francisco Bay Area Posts: 38,323	When you are doing your set-up, in the menu bar select Data, then Validation. In the pop-up, under the Settings tab, you can set the type of characters (validation criteria), and minimum/maximum number of characters. ADG Webmaster __________________ Asian Diva Girls - Exclusive Photos and Videos Asian Diva Girls Affiliate Program (50% ccBill Revshare)

01-25-2007, 08:35 PM	#2
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	GFY has no problem validating your 11 duplicate posts