Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Spaces may be slightly faster, but for me, they're extremely difficult to
noctice. But if I put ="" in a cell, I can select the cell and see it in the formula bar. Entering a space character adds some time when I want to find out what's in that cell. (Pay me now, or pay me later???) Max wrote: If you put something in the next cell it will not fill over, you could put ="" for instance Hitting a space would be slightly faster, no? <g But the OP did mention this .. hit the space button to make the field before it (with the sentence) think that its not empty, But thought that this part of the original post may not be quite correct, going by tests carried out here .. but that only works while you have it open, even if you save, the string comes back the next time you access the file. The space(s) remained where they were hit or copied down -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
input text at front of field that contains data | Excel Discussion (Misc queries) | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions |