Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
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 06:42:50
ModifyPoint:315 Replies:12 POST_ID:828685USER_ID:11575
Topic:
Microsoft Excel Spreadsheet Software;;Microsoft Office Suite
it look like a blank but that cell is not blank =ISBLANK the result is false. how can i know the value in cell?
Expert: duncanb7 replied at 2024-08-04 09:42:00
thanks, even just some point meaning , encourage EE members for sharing
Accepted Solution
Expert: byundt replied at 2024-08-03 10:28:03
105 points EXCELLENT
To get rid of the non-breaking spaces (ASCII 160):
1. Select one of the cells that looks blank, but isn't
2. Click in the formula bar
3. Hold the Shift key down, then hit the left arrow key. CTRl + c to copy the ASCII 160 character you selected.
4. Hit the Escape key to get out of edit mode
5. Open the Replace menu item, then CTRL + V to paste the ASCII 160 character in the Find field. Make sure the Replace field is empty.
6. Hit the Replace All button. I got 75,826 replacements.
To copy a value from the cell below:
1. Note the top left cell that got selected. In your sample worksheet, it is B28.
2. Select the range of cells to be updated. Don't select an entire column!
3. F5 then click Special Cells...
4. Choose Blanks from the resulting dialog, then click OK
5. Click in the formula bar and type a formula referring to the cell below B28:
=B29
6. Hold the Control key down, then hit Enter. This will put the formula in all the selected blank cells.
Note that most people want to copy the value from the cell above. If so, the formula in step 5 would be =B27
1. Select one of the cells that looks blank, but isn't
2. Click in the formula bar
3. Hold the Shift key down, then hit the left arrow key. CTRl + c to copy the ASCII 160 character you selected.
4. Hit the Escape key to get out of edit mode
5. Open the Replace menu item, then CTRL + V to paste the ASCII 160 character in the Find field. Make sure the Replace field is empty.
6. Hit the Replace All button. I got 75,826 replacements.
To copy a value from the cell below:
1. Note the top left cell that got selected. In your sample worksheet, it is B28.
2. Select the range of cells to be updated. Don't select an entire column!
3. F5 then click Special Cells...
4. Choose Blanks from the resulting dialog, then click OK
5. Click in the formula bar and type a formula referring to the cell below B28:
=B29
6. Hold the Control key down, then hit Enter. This will put the formula in all the selected blank cells.
Note that most people want to copy the value from the cell above. If so, the formula in step 5 would be =B27
Expert: duncanb7 replied at 2024-08-03 07:51:39
He want Excel cell edit, could you try it, code() on excel
Expert: MartinLiss replied at 2024-08-03 07:47:21
thanks, even just some point meaning , encourage EE members for sharing
Assisted Solution
Expert: Tony Barkdull replied at 2024-08-03 07:46:16
105 points EXCELLENT
Problem is the blanks cell is not blank. It has 7 blank spaces in it. If you remove the spaces, this would work
=IF(B28="",B29, B28)
This does require you to add a column to place ithis formula in. However, it fails if there is consecutive blanks cells. I added column C. See attached.
Just a word of advice. Try using punctuation in your questions. It is hard to read and understand otherwise. And it is "below", not "be low"
Hope this helps.
=IF(B28="",B29, B28)
This does require you to add a column to place ithis formula in. However, it fails if there is consecutive blanks cells. I added column C. See attached.
Just a word of advice. Try using punctuation in your questions. It is hard to read and understand otherwise. And it is "below", not "be low"
Hope this helps.
Expert: duncanb7 replied at 2024-08-03 07:39:12
What command you used for 160, if true, it is extra-Ascill code
Expert: MartinLiss replied at 2024-08-03 07:36:27
The asc value of all 7 characters is 160.
Expert: duncanb7 replied at 2024-08-03 07:32:31
the ascill for char is 63 or 43 for char ? or )
The file seem is corrupted, I think you need to re-build in the future after this thread
you can use code(right(b1,1)) to find out lsat char of string 's ascill code
The file seem is corrupted, I think you need to re-build in the future after this thread
you can use code(right(b1,1)) to find out lsat char of string 's ascill code
Expert: MartinLiss replied at 2024-08-03 07:26:25
It's very strange. Cell B31 contains a string of seven characters, all of then being "å" ("a" with an acute accent). I have no idea why the string is not visible and I made sure that the font was black.
Assisted Solution
Expert: duncanb7 replied at 2024-08-03 07:21:21
105 points EXCELLENT
Just use the following formual on new column that will solve it
=IF(LEN(B1)=0,"",IF(LEN(B1)<10,B2,B1))
=IF(LEN(B1)=0,"",IF(LEN(B1)<10,B2,B1))
Author: teera replied at 2024-08-03 06:51:47
b31 look like a blank I try to copy value from b32 to b31
and all of some cell like b31 i want to copy value from the cell be low it how can i do that
and all of some cell like b31 i want to copy value from the cell be low it how can i do that
Expert: duncanb7 replied at 2024-08-03 06:45:39
Could you send you xls file to us so that we understand what you are asking ?
