Register
Log In
Unanswered
Home
July 19, 2014
Offline
Hi :),
Here I have another issue to sort out.
Within a cell I must restrict such code.
Please find the attached file.
Best Regards,
Dritan
July 16, 2010
Offline
Hi Dritan,
You could use a custom formula in a data validation list, but my feeling is that it would be way too complicated as there are too many variables that aren't allowed.
You'd be better off splitting the input into it's 6 parts (6 columns) and then concatenating them again it in a 7th column with the colons separating each part. You can use a data validation list for the 6 parts that lists the input options in the correct case.
Mynda
Dashboards
June 25, 2016
Offline
Hi Dritan
Another suggestion is to allow user to input the data (excluding the colon) into one cell and then concatenating it in another to include the semi colon.
Whenever you need to key any data that have fixed delimiters, I would suggest leaving out the delimiters to make the inputting easier.
See attached.
Hope this helps.
Sunny
July 19, 2014
Offline
Hi SunnyKow,
You have provide a very smart way.
But please read my attached file, because still i cannot find a solution.
Best Regards,
Dritan
Dashboards
June 25, 2016
Offline
Hi Dritan
Under the Find And Replace - Find tab, change the Look in option to Values instead of Formulas.
You should be able to find them now.
Sunny
Most Users Ever Online: 57
Currently Online:
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
