Excel - Google isn't helping with this one - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » Excel - Google isn't helping with this one

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

A2H GO

Member

Registered: 14th Sep 04
Location: Stoke
User status: Offline

29th Oct 11 at 13:09

I want to prevent people from putting anything other than H,T, U,O followed by up to 3 numbers into a cell.

Like H7, H77, or H777.

Not 7H, H or H7777.

M2RTY

Member

Registered: 25th May 01
User status: Offline

29th Oct 11 at 14:31

Its under the custom format tab, where to tell it its text or currency etc

pow

Premium Member

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline

30th Oct 11 at 09:04

Data Validation

A2H GO

Member

Registered: 14th Sep 04
Location: Stoke
User status: Offline

30th Oct 11 at 10:22

Yep, think I need soothing along the lines of this:

=AND(ISNUMBER(SEARCH(LEFT(E17,1), "HTUO")), ISNUMBER(MID(E17,2,LEN(E17))+0), LEN(E17<=4))

Robbo

Member

Registered: 6th Aug 02
Location: London
User status: Offline

30th Oct 11 at 11:17

quote:
Originally posted by pow
Data Validation

Dom

Member

Registered: 13th Sep 03
User status: Offline

30th Oct 11 at 13:37

quote:
Originally posted by Robbo

quote:
Originally posted by pow
Data Validation

This, although IIRC it still allows you to paste anything to a cell so it isn't full proof.

Edit - VBA would probably be the best solution, could also regex it (plenty of VBA examples on google)

[Edited on 30-10-2011 by Dom]

New Topic

New Poll