Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Long Documents / March 2004

Tip: Looking for answers? Try searching our database.

Replace Spaces With Tabs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Larry R Harrison Jr - 09 Mar 2004 19:36 GMT
I have a long TXT type document with a column-like layout which I need to
load into Word, go throughout it, strip the spaces between the columns and
replace them with tab-stops. The end-of-the-line breaks of paragraphs
(hard-ones, I believe) need to remain that way so they're not an issue.

Since the data in columns is words which does contain spaces between each
word, obviously you would NOT want to replace THOSE spaces with tab
stops--only the multiple spaces between each column.

By the way, there is NOT the same amount of spaces between each column
either.

I would imagine this would require some Visual Basic. I have quite a bit of
fluency in that with regards to Access, far less so with Word, Excel etc.

Tips?

Seems though Excel converts it cleaner, so if somehow Excel could do it but
then keep tabs between the columns yet carriage-returns at the end of the
line that may work. Don't know.

Again, tips?

LRH
Greg Maxey - 09 Mar 2004 20:18 GMT
Larry,

Have you tried Edit>Replace>More>Use Wildcards

Type"
{2,} in the find what field (that is a space before the
leading {
and
^t in the replace with field

>-----Original Message-----
>I have a long TXT type document with a column-like layout which I need to
[quoted text clipped - 23 lines]
>
>.
Brandon - 09 Mar 2004 20:25 GMT
Just an idea:

Determine the smallest number of spaces between columns.
then do a global F/R, and replace it with a tab stop.
Then do multiple runs of F/R, replacing each instance of
^t[space] with ^t.

Brandon

>-----Original Message-----
>I have a long TXT type document with a column-like layout which I need to
[quoted text clipped - 23 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.