Jump to content

Recommended Posts

Posted

help!

How can one convert a text to table (like in word) with several lines of data in MS word.? It is also mixed with paragraphs. I am stumped

 

an an example looks like this

 

image.png.d6dd7901382e5e0228ab3588988b95e3.png

Posted

Welcome to the forum.

The Microsoft Office UDFs may help you with some of the important bits. See the Help file User Defined Functions Reference section at the end.

But if you are wanting to detect what is just paragraph text as opposed to table text, I would check each line for a TAB character maybe ... or more than one, using StringInStr, plus using StringSplit first (to create an array) to get each line based on a carriage return as the separator.

Have a go at that if you want, and if you have any difficulties, post what code you have tried, here, and you should get help easily.

If you give us something, code wise, to work with, then it will give us a clearer picture of how best to target our help to you.

Make sure brain is in gear before opening mouth!
Remember, what is not said, can be just as important as what is said.

Spoiler

What is the Secret Key? Life is like a Donut

If I put effort into communication, I expect you to read properly & fully, or just not comment.
Ignoring those who try to divert conversation with irrelevancies.
If I'm intent on insulting you or being rude, I will be obvious, not ambiguous about it.
I'm only big and bad, to those who have an over-active imagination.

I may have the Artistic Liesense ;) to disagree with you. TheSaint's Toolbox (be advised many downloads are not working due to ISP screwup with my storage)

userbar.png

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...