Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by teera
at 2024-08-03 01:23:12
ModifyPoint:330 Replies:2 POST_ID:828678USER_ID:11575
Topic:
Microsoft Office Suite;;Microsoft Excel Spreadsheet Software
how can I check the value in cell that is blank and some cell is space
Assisted Solution
Expert: duncanb7 replied at 2024-08-03 01:40:07
165 points EXCELLENT
isblank() is correct for first checking blank
=isblank(a1) //output true or false
and for check space
=If (LEN(TRIM(a1)=0,true,false)
=isblank(a1) //output true or false
and for check space
=If (LEN(TRIM(a1)=0,true,false)
Accepted Solution
Expert: Carol Chisholm replied at 2024-08-03 01:28:33
165 points EXCELLENT
=isblank() will tell you the blanks
=trim() will get rid of spaces.
Do you want to keep the spaces?
=trim() will get rid of spaces.
Do you want to keep the spaces?
