A shot in the dark

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

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.




"Rodney" wrote in message
...
: 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 EditReplace
: |
: | What: ALT + 0010 (on NumPad)
: |
: | With: nothing
: |
: | Replace all.
: |
: |
: | Gord Dibben Excel MVP
: |
: | On Fri, 20 May 2005 10:07:45 +0800, "Rodney"
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
: |
: |
: |
:
:

Rodney

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

In Excel you would EditReplace

What: ALT + 0010 (on NumPad)

With: nothing

Replace all.


Gord Dibben Excel MVP

On Fri, 20 May 2005 10:07:45 +0800, "Rodney" 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 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 EditReplace
|
| What: ALT + 0010 (on NumPad)
|
| With: nothing
|
| Replace all.
|
|
| Gord Dibben Excel MVP
|
| On Fri, 20 May 2005 10:07:45 +0800, "Rodney" 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
|
|
|

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

On Sat, 21 May 2005 08:43:08 +0800, "Rodney" wrote:

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 EditReplace
|
| What: ALT + 0010 (on NumPad)
|
| With: nothing
|
| Replace all.
|
|
| Gord Dibben Excel MVP
|
| On Fri, 20 May 2005 10:07:45 +0800, "Rodney" 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
|
|
|

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
|
| On Sat, 21 May 2005 08:43:08 +0800, "Rodney" wrote:
|
| 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 EditReplace
| |
| | What: ALT + 0010 (on NumPad)
| |
| | With: nothing
| |
| | Replace all.
| |
| |
| | Gord Dibben Excel MVP
| |
| | On Fri, 20 May 2005 10:07:45 +0800, "Rodney" 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
| |
| |
| |
|
|

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!




"Lady Layla" wrote in message ...
| 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.
|
|
|
|
| "Rodney" wrote in message
| ...
| : 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 EditReplace
| : |
| : | What: ALT + 0010 (on NumPad)
| : |
| : | With: nothing
| : |
| : | Replace all.
| : |
| : |
| : | Gord Dibben Excel MVP
| : |
| : | On Fri, 20 May 2005 10:07:45 +0800, "Rodney"
| 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 EditReplace
| | : |
| | : | What: ALT + 0010 (on NumPad)
| | : |
| | : | With: nothing
| | : |
| | : | Replace all.
| | : |
| | : |
| | : | Gord Dibben Excel MVP
| | : |
| | : | On Fri, 20 May 2005 10:07:45 +0800, "Rodney"
| | 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.
| |
| |
| |
| |
| | "Rodney" wrote in message
| | ...
| | : 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 EditReplace
| | : |
| | : | What: ALT + 0010 (on NumPad)
| | : |
| | : | With: nothing
| | : |
| | : | Replace all.
| | : |
| | : |
| | : | Gord Dibben Excel MVP
| | : |
| | : | On Fri, 20 May 2005 10:07:45 +0800, "Rodney"
| | 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?





"Rodney" wrote in message
...
: 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.
: | |
: | |
: | |
: | |
: | | "Rodney" wrote in message
: | | ...
: | | : 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 EditReplace
: | | : |
: | | : | What: ALT + 0010 (on NumPad)
: | | : |
: | | : | With: nothing
: | | : |
: | | : | Replace all.
: | | : |
: | | : |
: | | : | Gord Dibben Excel MVP
: | | : |
: | | : | On Fri, 20 May 2005 10:07:45 +0800, "Rodney"

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