Thanks for pointing that out.

I have the original data in an excel table. This data needs to be Inserted in the Sql database editor. I need to add the quotes,commas,brackets to it before i insert it.

I therefore copied and pasted this data from excel to word as text only in order to add brackets and quotes etc.

I turned on the show hide button to check if the spacing is correct and it shows a tab marker(arrow) seperating the words instead of a space marker.

I know its asking a lot but is it posisble you could alter the code.

Gmayor, 160 didnt work. Ive attached a sample doc as original is too big. Hope it uploads correct

Attached Files

For Web.docx (12.5 KB, 16 views)

Use Chr(9) in place of Chr(32) for the tab.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Your sample document has tabs, not spaces, between the strings. Do you want tabs, or spaces, in the output?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]