Hi Steve,
I'm not sure of a lot about your problem. For example, if you want to do
this in Excel, why are you writing to a Word newsgroup? I'll assume that
you're starting in Word and only intend to use Text to Columns in Excel (but
Word has this functionality). Here's my test document (where "Interior
Design is boldfaced):
Interior Design A magazine on the interior design industry
Interior Design A magazine on the interior design industry
Interior Design A magazine on the interior design industry
Interior Design A magazine on the interior design industry
Interior Design A magazine on the interior design industry
Interior Design A magazine on the interior design industry
Here's the routine I used to change this to a table
With Selection
.HomeKey unit:=wdStory
With .Find
.ClearFormatting
.Font.Bold = True
.Text = ""
Do While .Execute
With Selection
.InsertAfter Text:="@"
.MoveRight
End With
Loop
End With
End With
ActiveDocument.Range.ConvertToTable Separator:="@", NumColumns:=2
Now, main problem is this: If you have any other boldface formatting, I
cannot gaurantee this to work, and I don't know of an efficient workaround.
HTH and good luck,
Dave
> Hi,
>
[quoted text clipped - 15 lines]
>
> Thanks - Steve
Steve - 03 Dec 2004 19:27 GMT
Thank you for your help, Steve
Gene - 20 Dec 2004 19:26 GMT
I have to thank you too! This resolved my bottleneck today with a little
modification.

Signature
Thanks,
Gene
> Hi Steve,
>
[quoted text clipped - 64 lines]
> >
> > Thanks - Steve