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.
|
Nou pe simpatie:
sayler_moon_19 din Bacau
 | Femeie
25 ani
Bacau
cauta Barbat
26 - 46 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
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:
https://www.extendoffice.com/documents/ ... paces.html
|
|
| |
|
