Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
NothingButRomance
 
Posts: n/a
Default Stop text from stringing into next field when empty


Thanks Max! You are absolutely right! I did try it again and they are
saved. Not sure what happened when I tried it before, but I couldn't
get it to show correctly after saving and reopening. This time it did.
My only problem now is, when I go into that field/cell in the future, I
will have to deal with the space, right? That field/cell is the most
important cell after the database is setup and the other fields/cells
before it are locked. This is where we will put the inventory and pay
attention to see if we have one of each book in that series so that we
can gather them and post them to auction. Guess if we leave the space
in there for ALL of them in the row, they will still line up the same
and be easily read....right? it would be easier then deleting ='s from
each cell when typing in the box number.

Thanks so much again!!!!
Lalla
Owner & Web Designer : www.NothingButRomance.com
Web designer : www.WaresEthnicCeramics.com



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 atyahoodotcom
----



--
NothingButRomance
  #2   Report Post  
Max
 
Posts: n/a
Default

You're welcome !
Glad you got the correct behaviour the 2nd time round <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----


Reply
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
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 7 May 17th 05 02:22 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 02:55 AM.

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

About Us

"It's about Microsoft Excel"