[Nicole Beath]

My client database was corrupted when an illegal operation occured on my
machine. This was in table format though after corruption the table was
removed and the columns have been separated with a character (ie square) that
is unrecognisable in WORD! I have searched the discussion forums and cannot
locate a similar issue. Could anyone shed any light in coverting this back
into table format please. Thank you.

[Jay Freedman]

Even though the character displays as a square, you may be able to
replace it with a valid delimiter.

Select one of these squares and copy it to the clipboard. Open the
Replace dialog. Paste the character from the clipboard (using Ctrl+V)
into the Find What box. If you want the delimiter to be a comma, type
a comma in the Replace With box; if you want it to be a tab, type the
code ^t in the Replace With box. Click the Replace All button and
see what happens.

If that doesn't do the whole job, come back and tell us what happened.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Mon, 5 Mar 2007 14:49:25 -0800, Nicole Beath Nicole
wrote:

My client database was corrupted when an illegal operation occured on my
machine. This was in table format though after corruption the table was
removed and the columns have been separated with a character (ie square) that
is unrecognisable in WORD! I have searched the discussion forums and cannot
locate a similar issue. Could anyone shed any light in coverting this back
into table format please. Thank you.

[Nicole Beath[_2_]]

Thanks for the reply Jay! I have tried your method thought the character is
not being recognised by WORD when i try to paste it (i tried ctrl v and also
via the icon - no success) in 'Find/Replace'. I dont think the square (or
upside down rectangle) is in fact a character as I would be able to cut/paste
(even a symbol) into other applications. I can cut and paste (using quick
keys/icons) into the same document though that is it. I have cut/pasted a
segment of the doc (see below - eg1) - as you can see the sq/rect is not
showing and there is no break in the text:

(eg1): 981005Grosper Pty Limited (Marty Perry)Application for Off-Licence
(Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly
Hills17.07.9719.12.970071 (Box 4)

Where I require the tabs is as follows (see below eg2 @ *)

(eg2): 981005**Grosper Pty Limited (Marty Perry)*Application for Off-Licence
(Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly
Hills*17.07.97*19.12.97*0071 (Box 4)**

This document is driving me crazy.... i've exhausted all avenues in the help
system - please save me Jay!!

"Jay Freedman" wrote:

Even though the character displays as a square, you may be able to
replace it with a valid delimiter.

Select one of these squares and copy it to the clipboard. Open the
Replace dialog. Paste the character from the clipboard (using Ctrl+V)
into the Find What box. If you want the delimiter to be a comma, type
a comma in the Replace With box; if you want it to be a tab, type the
code ^t in the Replace With box. Click the Replace All button and
see what happens.

If that doesn't do the whole job, come back and tell us what happened.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Mon, 5 Mar 2007 14:49:25 -0800, Nicole Beath Nicole
wrote:

My client database was corrupted when an illegal operation occured on my
machine. This was in table format though after corruption the table was
removed and the columns have been separated with a character (ie square) that
is unrecognisable in WORD! I have searched the discussion forums and cannot
locate a similar issue. Could anyone shed any light in coverting this back
into table format please. Thank you.

[macropod]

Hi Nicole,

Try copying the character by selecting it then pressing Ctrl-C. Then paste into the 'Find' box.

If that doesn't work, try copying a single whole string into Excel, then deleting all except one problem character. Then, in an
adjoining cell, enter =CODE(A1), where A1 is the cell you pasted the text into. What value does Excel return? Back in Word, open the
'Find' box and hold down the Alt key while inputting the number Excel gave you as a 3-digit value (add leading 0s if needed).

Cheers

--
macropod
[MVP - Microsoft Word]
-------------------------

"Nicole Beath" wrote in message ...
Thanks for the reply Jay! I have tried your method thought the character is
not being recognised by WORD when i try to paste it (i tried ctrl v and also
via the icon - no success) in 'Find/Replace'. I dont think the square (or
upside down rectangle) is in fact a character as I would be able to cut/paste
(even a symbol) into other applications. I can cut and paste (using quick
keys/icons) into the same document though that is it. I have cut/pasted a
segment of the doc (see below - eg1) - as you can see the sq/rect is not
showing and there is no break in the text:

(eg1): 981005Grosper Pty Limited (Marty Perry)Application for Off-Licence
(Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly
Hills17.07.9719.12.970071 (Box 4)

Where I require the tabs is as follows (see below eg2 @ *)

(eg2): 981005**Grosper Pty Limited (Marty Perry)*Application for Off-Licence
(Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly
Hills*17.07.97*19.12.97*0071 (Box 4)**

This document is driving me crazy.... i've exhausted all avenues in the help
system - please save me Jay!!

"Jay Freedman" wrote:

Even though the character displays as a square, you may be able to
replace it with a valid delimiter.

Select one of these squares and copy it to the clipboard. Open the
Replace dialog. Paste the character from the clipboard (using Ctrl+V)
into the Find What box. If you want the delimiter to be a comma, type
a comma in the Replace With box; if you want it to be a tab, type the
code ^t in the Replace With box. Click the Replace All button and
see what happens.

If that doesn't do the whole job, come back and tell us what happened.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Mon, 5 Mar 2007 14:49:25 -0800, Nicole Beath Nicole
wrote:

My client database was corrupted when an illegal operation occured on my
machine. This was in table format though after corruption the table was
removed and the columns have been separated with a character (ie square) that
is unrecognisable in WORD! I have searched the discussion forums and cannot
locate a similar issue. Could anyone shed any light in coverting this back
into table format please. Thank you.

[Klaus Linke]

Or try ^7 for the square, which is the control character Word usually uses
for end-of-cell and end-of-row markers.

Good luck,
Klaus


"macropod" schrieb im Newsbeitrag
...
Hi Nicole,

Try copying the character by selecting it then pressing Ctrl-C. Then
paste into the 'Find' box.

If that doesn't work, try copying a single whole string into Excel, then
deleting all except one problem character. Then, in an adjoining cell,
enter =CODE(A1), where A1 is the cell you pasted the text into. What value
does Excel return? Back in Word, open the 'Find' box and hold down the Alt
key while inputting the number Excel gave you as a 3-digit value (add
leading 0s if needed).

Cheers

--
macropod
[MVP - Microsoft Word]
-------------------------

"Nicole Beath" wrote in message
...
Thanks for the reply Jay! I have tried your method thought the character
is
not being recognised by WORD when i try to paste it (i tried ctrl v and
also
via the icon - no success) in 'Find/Replace'. I dont think the square (or
upside down rectangle) is in fact a character as I would be able to
cut/paste
(even a symbol) into other applications. I can cut and paste (using quick
keys/icons) into the same document though that is it. I have cut/pasted a
segment of the doc (see below - eg1) - as you can see the sq/rect is not
showing and there is no break in the text:

(eg1): 981005Grosper Pty Limited (Marty Perry)Application for Off-Licence
(Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly
Hills17.07.9719.12.970071 (Box 4)

Where I require the tabs is as follows (see below eg2 @ *)

(eg2): 981005**Grosper Pty Limited (Marty Perry)*Application for
Off-Licence
(Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly
Hills*17.07.97*19.12.97*0071 (Box 4)**

This document is driving me crazy.... i've exhausted all avenues in the
help
system - please save me Jay!!

"Jay Freedman" wrote:

Even though the character displays as a square, you may be able to
replace it with a valid delimiter.

Select one of these squares and copy it to the clipboard. Open the
Replace dialog. Paste the character from the clipboard (using Ctrl+V)
into the Find What box. If you want the delimiter to be a comma, type
a comma in the Replace With box; if you want it to be a tab, type the
code ^t in the Replace With box. Click the Replace All button and
see what happens.

If that doesn't do the whole job, come back and tell us what happened.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Mon, 5 Mar 2007 14:49:25 -0800, Nicole Beath Nicole
wrote:

My client database was corrupted when an illegal operation occured on
my
machine. This was in table format though after corruption the table was
removed and the columns have been separated with a character (ie
square) that
is unrecognisable in WORD! I have searched the discussion forums and
cannot
locate a similar issue. Could anyone shed any light in coverting this
back
into table format please. Thank you.