Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Yuby Mona
 | Femeie
23 ani
Arges
cauta Barbat
23 - 45 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
1. Select a column that you need to prevent spaces when you enter data.
2. Click Data > Data Validation > Data Validation
3. In the Data Validation dialog box, click Settings tab, and choose Custom from the Allow drop down list, then enter this formula =NOT(ISNUMBER(SEARCH(" ";A1))) into the Formula text box.
Note: A1 indicates the first cell of your selected column.
4. After finishing the settings, click OK to close this dialog. And now, when you input spaces within your data in the column which you have specified, you will get the following warning message.
Source with screenshots:
Modificat de TRaP (acum 6 ani)
|
|
| pus acum 6 ani |
|