Data Validation

Resolved · High Priority · Version 2010

Tue 11 Jul 2017, 15:27 Delegate Kane said...

Kane has attended:
Excel Advanced course
Excel Advanced course

Data Validation

Hi,

I have put data validation on cells so the it has to be 11 characters long only. However, if you cut and paste less or more in the cells the data validation does not work. Is there a way around this please?

Regards

Kane

Thu 13 Jul 2017, 10:21 Trainer Jens said...

RE: Data Validation

Hi Kane,

Thank you for the forum question.

It can be done, but you will have to write a VBA code in the workbook. I do not know if you have VBA knowledge if not unfortunately you cannot prevent someone to paste into the cells with datavalidation.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 20 Jul 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips