A shot in the dark

  • Thread starter Thread starter Rodney
  • Start date Start date
R

Rodney

We are using Excel's sibling MSWorks
and have a curious problem.
In a Database cell, we can add lines to the cell
in "Report View" by employing an "End Of Line" character.
(In Excel it's the same with ALT/Enter)

In MSWorks "list view" the EOL character appears as a square box.

What we need to know is there anyway of removing
this EOL character (the square box) "en-masse"
Seems a singular physical delete is the only option.

We have tried the "replace" option, no good

Our resident MVP is away at the mo, so thought I'd chance a request here.

Anybody?

Thanks
 
Rodney

What did you try for the "replace" option that did not work?

In Excel you would Edit>Replace

What: ALT + 0010 (on NumPad)

With: nothing

Replace all.


Gord Dibben Excel MVP
 
G'day Gordon,
here is the enigma.........
http://cjoint.com/data/fvcUQjBTfO.htm

What we seek is to remove the little square boxes,
It looks impossible, apart from individually going to
the cell and deleting.

Edit / Replace and using the num pad will not work in MSWorks

Here is the OP post..............

I read sometime ago in a magazine what I think was the answer to this
question.
I wish I had written it down at the time
The reason I want this is I import the data for the field from Eudora,
Its the output of a form on my website, and regularly people put and
"End of Line" character in the form by pressing enter.
The EoL then poses a problem in my database and I have to remove them.
I would like to search and replace if I could rather than doing it all
one by one.


"Gord Dibben" <gorddibbATshawDOTca> wrote in message | Rodney
|
| What did you try for the "replace" option that did not work?
|
| In Excel you would Edit>Replace
|
| What: ALT + 0010 (on NumPad)
|
| With: nothing
|
| Replace all.
|
|
| Gord Dibben Excel MVP
|
|
| >
| >We are using Excel's sibling MSWorks
| >and have a curious problem.
| >In a Database cell, we can add lines to the cell
| >in "Report View" by employing an "End Of Line" character.
| >(In Excel it's the same with ALT/Enter)
| >
| >In MSWorks "list view" the EOL character appears as a square box.
| >
| >What we need to know is there anyway of removing
| >this EOL character (the square box) "en-masse"
| >Seems a singular physical delete is the only option.
| >
| >We have tried the "replace" option, no good
| >
| >Our resident MVP is away at the mo, so thought I'd chance a request here.
| >
| >Anybody?
| >
| >Thanks
| >
| >
|
 
I can only speak for Excel, not MS Works.

Since you posted in an Excel news group, I suggested an Excel fix.

If it doesn't help in Works, perhaps a trip to an MS Works news group would
serve you better.

http://aumha.org/nntp.htm for a list of groups.


Gord
 
Yep, it was a shot in the dark.
we are awaiting the return of our MVP in MSWorks.
Thanks Gord.



"Gord Dibben" <gorddibbATshawDOTca> wrote in message | I can only speak for Excel, not MS Works.
|
| Since you posted in an Excel news group, I suggested an Excel fix.
|
| If it doesn't help in Works, perhaps a trip to an MS Works news group would
| serve you better.
|
| http://aumha.org/nntp.htm for a list of groups.
|
|
| Gord
|
|
| >G'day Gordon,
| >here is the enigma.........
| >http://cjoint.com/data/fvcUQjBTfO.htm
| >
| >What we seek is to remove the little square boxes,
| >It looks impossible, apart from individually going to
| >the cell and deleting.
| >
| >Edit / Replace and using the num pad will not work in MSWorks
| >
| >Here is the OP post..............
| >
| >I read sometime ago in a magazine what I think was the answer to this
| >question.
| >I wish I had written it down at the time
| >The reason I want this is I import the data for the field from Eudora,
| >Its the output of a form on my website, and regularly people put and
| >"End of Line" character in the form by pressing enter.
| >The EoL then poses a problem in my database and I have to remove them.
| >I would like to search and replace if I could rather than doing it all
| >one by one.
| >
| >
| >"Gord Dibben" <gorddibbATshawDOTca> wrote in message | >| Rodney
| >|
| >| What did you try for the "replace" option that did not work?
| >|
| >| In Excel you would Edit>Replace
| >|
| >| What: ALT + 0010 (on NumPad)
| >|
| >| With: nothing
| >|
| >| Replace all.
| >|
| >|
| >| Gord Dibben Excel MVP
| >|
| >|
| >| >
| >| >We are using Excel's sibling MSWorks
| >| >and have a curious problem.
| >| >In a Database cell, we can add lines to the cell
| >| >in "Report View" by employing an "End Of Line" character.
| >| >(In Excel it's the same with ALT/Enter)
| >| >
| >| >In MSWorks "list view" the EOL character appears as a square box.
| >| >
| >| >What we need to know is there anyway of removing
| >| >this EOL character (the square box) "en-masse"
| >| >Seems a singular physical delete is the only option.
| >| >
| >| >We have tried the "replace" option, no good
| >| >
| >| >Our resident MVP is away at the mo, so thought I'd chance a request here.
| >| >
| >| >Anybody?
| >| >
| >| >Thanks
| >| >
| >| >
| >|
| >
|
 
Hey! you might have something there Lady Layla.
I'll try it first thing.
I am being forcefully beckoned from the child's bedroom
as "story time" is nigh.
Thanks!




| Can you define what "using the num pad will not work in MSWorks" means?
|
| If you can Replace -- as you indicated in your OP, then this method will work.
| You can also pull open the Character Map Program (Start Accessories System
| Tools) find the Character Copy it and paste it in the Find box for Works.
|
|
|
|
| | : G'day Gordon,
| : here is the enigma.........
| : http://cjoint.com/data/fvcUQjBTfO.htm
| :
| : What we seek is to remove the little square boxes,
| : It looks impossible, apart from individually going to
| : the cell and deleting.
| :
| : Edit / Replace and using the num pad will not work in MSWorks
| :
| : Here is the OP post..............
| :
| : I read sometime ago in a magazine what I think was the answer to this
| : question.
| : I wish I had written it down at the time
| : The reason I want this is I import the data for the field from Eudora,
| : Its the output of a form on my website, and regularly people put and
| : "End of Line" character in the form by pressing enter.
| : The EoL then poses a problem in my database and I have to remove them.
| : I would like to search and replace if I could rather than doing it all
| : one by one.
| :
| :
| : "Gord Dibben" <gorddibbATshawDOTca> wrote in message
| | : | Rodney
| : |
| : | What did you try for the "replace" option that did not work?
| : |
| : | In Excel you would Edit>Replace
| : |
| : | What: ALT + 0010 (on NumPad)
| : |
| : | With: nothing
| : |
| : | Replace all.
| : |
| : |
| : | Gord Dibben Excel MVP
| : |
| : | On Fri, 20 May 2005 10:07:45 +0800, "Rodney" <[email protected]>
| wrote:
| : |
| : | >
| : | >We are using Excel's sibling MSWorks
| : | >and have a curious problem.
| : | >In a Database cell, we can add lines to the cell
| : | >in "Report View" by employing an "End Of Line" character.
| : | >(In Excel it's the same with ALT/Enter)
| : | >
| : | >In MSWorks "list view" the EOL character appears as a square box.
| : | >
| : | >What we need to know is there anyway of removing
| : | >this EOL character (the square box) "en-masse"
| : | >Seems a singular physical delete is the only option.
| : | >
| : | >We have tried the "replace" option, no good
| : | >
| : | >Our resident MVP is away at the mo, so thought I'd chance a request here.
| : | >
| : | >Anybody?
| : | >
| : | >Thanks
| : | >
| : | >
| : |
| :
| :
|
|
 
G'day Lady Layla,
unfortunately, your solution failed to work.

| | Can you define what "using the num pad will not work in MSWorks" means?

Generally, when entering code one use the ALT key and number pad,
in "Replace" in MSWorks the ALT codes do not work with the code
representing the square box (ALT+0143) plus a host of others.

| | If you can Replace -- as you indicated in your OP, then this method will work.
| | You can also pull open the Character Map Program (Start Accessories System
| | Tools) find the Character Copy it and paste it in the Find box for Works.



| | : G'day Gordon,
| | : here is the enigma.........
| | : http://cjoint.com/data/fvcUQjBTfO.htm
| | :
| | : What we seek is to remove the little square boxes,
| | : It looks impossible, apart from individually going to
| | : the cell and deleting.
| | :
| | : Edit / Replace and using the num pad will not work in MSWorks
| | :
| | : Here is the OP post..............
| | :
| | : I read sometime ago in a magazine what I think was the answer to this
| | : question.
| | : I wish I had written it down at the time
| | : The reason I want this is I import the data for the field from Eudora,
| | : Its the output of a form on my website, and regularly people put and
| | : "End of Line" character in the form by pressing enter.
| | : The EoL then poses a problem in my database and I have to remove them.
| | : I would like to search and replace if I could rather than doing it all
| | : one by one.
| | :
| | :
| | : "Gord Dibben" <gorddibbATshawDOTca> wrote in message
| | | | : | Rodney
| | : |
| | : | What did you try for the "replace" option that did not work?
| | : |
| | : | In Excel you would Edit>Replace
| | : |
| | : | What: ALT + 0010 (on NumPad)
| | : |
| | : | With: nothing
| | : |
| | : | Replace all.
| | : |
| | : |
| | : | Gord Dibben Excel MVP
| | : |
| | : | On Fri, 20 May 2005 10:07:45 +0800, "Rodney" <[email protected]>
| | wrote:
| | : |
| | : | >
| | : | >We are using Excel's sibling MSWorks
| | : | >and have a curious problem.
| | : | >In a Database cell, we can add lines to the cell
| | : | >in "Report View" by employing an "End Of Line" character.
| | : | >(In Excel it's the same with ALT/Enter)
| | : | >
| | : | >In MSWorks "list view" the EOL character appears as a square box.
| | : | >
| | : | >What we need to know is there anyway of removing
| | : | >this EOL character (the square box) "en-masse"
| | : | >Seems a singular physical delete is the only option.
| | : | >
| | : | >We have tried the "replace" option, no good
| | : | >
| | : | >Our resident MVP is away at the mo, so thought I'd chance a request here.
| | : | >
| | : | >Anybody?
| | : | >
| | : | >Thanks
| | : | >
| | : | >
| | : |
| | :
| | :
| |
| |
|
|
 
When you paste the cells contents
to a word proc doc, the EOL characters
come out thus...
http://cjoint.com/data/fzeb32fdiW.htm

I don't think there is a corresponding character
rec in the map.

We'll just have to leave it as an enigma.






| | Can you define what "using the num pad will not work in MSWorks" means?
| |
| | If you can Replace -- as you indicated in your OP, then this method will work.
| | You can also pull open the Character Map Program (Start Accessories System
| | Tools) find the Character Copy it and paste it in the Find box for Works.
| |
| |
| |
| |
| | | | : G'day Gordon,
| | : here is the enigma.........
| | : http://cjoint.com/data/fvcUQjBTfO.htm
| | :
| | : What we seek is to remove the little square boxes,
| | : It looks impossible, apart from individually going to
| | : the cell and deleting.
| | :
| | : Edit / Replace and using the num pad will not work in MSWorks
| | :
| | : Here is the OP post..............
| | :
| | : I read sometime ago in a magazine what I think was the answer to this
| | : question.
| | : I wish I had written it down at the time
| | : The reason I want this is I import the data for the field from Eudora,
| | : Its the output of a form on my website, and regularly people put and
| | : "End of Line" character in the form by pressing enter.
| | : The EoL then poses a problem in my database and I have to remove them.
| | : I would like to search and replace if I could rather than doing it all
| | : one by one.
| | :
| | :
| | : "Gord Dibben" <gorddibbATshawDOTca> wrote in message
| | | | : | Rodney
| | : |
| | : | What did you try for the "replace" option that did not work?
| | : |
| | : | In Excel you would Edit>Replace
| | : |
| | : | What: ALT + 0010 (on NumPad)
| | : |
| | : | With: nothing
| | : |
| | : | Replace all.
| | : |
| | : |
| | : | Gord Dibben Excel MVP
| | : |
| | : | On Fri, 20 May 2005 10:07:45 +0800, "Rodney" <[email protected]>
| | wrote:
| | : |
| | : | >
| | : | >We are using Excel's sibling MSWorks
| | : | >and have a curious problem.
| | : | >In a Database cell, we can add lines to the cell
| | : | >in "Report View" by employing an "End Of Line" character.
| | : | >(In Excel it's the same with ALT/Enter)
| | : | >
| | : | >In MSWorks "list view" the EOL character appears as a square box.
| | : | >
| | : | >What we need to know is there anyway of removing
| | : | >this EOL character (the square box) "en-masse"
| | : | >Seems a singular physical delete is the only option.
| | : | >
| | : | >We have tried the "replace" option, no good
| | : | >
| | : | >Our resident MVP is away at the mo, so thought I'd chance a request here.
| | : | >
| | : | >Anybody?
| | : | >
| | : | >Thanks
| | : | >
| | : | >
| | : |
| | :
| | :
| |
| |
|
|
 


Ariel font - 6th row down on character map



Does Works Spreadsheet have the TRIM function?





: When you paste the cells contents
: to a word proc doc, the EOL characters
: come out thus...
: http://cjoint.com/data/fzeb32fdiW.htm
:
: I don't think there is a corresponding character
: rec in the map.
:
: We'll just have to leave it as an enigma.
:
:
:
:
:
:
: | | Can you define what "using the num pad will not work in MSWorks" means?
: | |
: | | If you can Replace -- as you indicated in your OP, then this method will
work.
: | | You can also pull open the Character Map Program (Start Accessories System
: | | Tools) find the Character Copy it and paste it in the Find box for Works.
: | |
: | |
: | |
: | |
: | | : | | : G'day Gordon,
: | | : here is the enigma.........
: | | : http://cjoint.com/data/fvcUQjBTfO.htm
: | | :
: | | : What we seek is to remove the little square boxes,
: | | : It looks impossible, apart from individually going to
: | | : the cell and deleting.
: | | :
: | | : Edit / Replace and using the num pad will not work in MSWorks
: | | :
: | | : Here is the OP post..............
: | | :
: | | : I read sometime ago in a magazine what I think was the answer to this
: | | : question.
: | | : I wish I had written it down at the time
: | | : The reason I want this is I import the data for the field from Eudora,
: | | : Its the output of a form on my website, and regularly people put and
: | | : "End of Line" character in the form by pressing enter.
: | | : The EoL then poses a problem in my database and I have to remove them.
: | | : I would like to search and replace if I could rather than doing it all
: | | : one by one.
: | | :
: | | :
: | | : "Gord Dibben" <gorddibbATshawDOTca> wrote in message
: | | : | | : | Rodney
: | | : |
: | | : | What did you try for the "replace" option that did not work?
: | | : |
: | | : | In Excel you would Edit>Replace
: | | : |
: | | : | What: ALT + 0010 (on NumPad)
: | | : |
: | | : | With: nothing
: | | : |
: | | : | Replace all.
: | | : |
: | | : |
: | | : | Gord Dibben Excel MVP
: | | : |
: | | : | On Fri, 20 May 2005 10:07:45 +0800, "Rodney"
<[email protected]>
: | | wrote:
: | | : |
: | | : | >
: | | : | >We are using Excel's sibling MSWorks
: | | : | >and have a curious problem.
: | | : | >In a Database cell, we can add lines to the cell
: | | : | >in "Report View" by employing an "End Of Line" character.
: | | : | >(In Excel it's the same with ALT/Enter)
: | | : | >
: | | : | >In MSWorks "list view" the EOL character appears as a square box.
: | | : | >
: | | : | >What we need to know is there anyway of removing
: | | : | >this EOL character (the square box) "en-masse"
: | | : | >Seems a singular physical delete is the only option.
: | | : | >
: | | : | >We have tried the "replace" option, no good
: | | : | >
: | | : | >Our resident MVP is away at the mo, so thought I'd chance a request
here.
: | | : | >
: | | : | >Anybody?
: | | : | >
: | | : | >Thanks
: | | : | >
: | | : | >
: | | : |
: | | :
: | | :
: | |
: | |
: |
: |
:
:
 
PS. if you wish, I can paste the
character into an Excel sheet, and send it to you
if you wish to try to remove it from there.
Rodney



| G'day Lady Layla,
| I like your tenacity and your thought process,
| this little blighter will <not> go away :)
| probably machine code?
|
| trim function
| http://cjoint.com/data/fBbWQKJLKN.htm
|
| Best Regards
| Rodney
|
|
 
Back
Top