LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel save as csv - force text qualifier on every text field Newbie-Don Excel Discussion (Misc queries) 6 April 2nd 23 08:33 PM
input text at front of field that contains data Steve M Excel Discussion (Misc queries) 3 May 16th 05 12:28 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 2 May 15th 05 05:32 PM
save text field w/ leading zeros in .csv format & not lose zeros? Ques Excel Discussion (Misc queries) 1 May 4th 05 06:21 PM
Pivot Tables..I give up... Debutante Excel Worksheet Functions 4 January 21st 05 10:43 PM


All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"