Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-29-2015, 08:35 AM
Marco Marco is offline from text to table, with conditions depending on format Windows Vista from text to table, with conditions depending on format Office 2007
Novice
from text to table, with conditions depending on format
 
Join Date: Apr 2015
Posts: 15
Marco is on a distinguished road
Default from text to table, with conditions depending on format


Hello, is there anyone willing to help me with this problem?

I have a text formed by several short lines.
Each line start with either one word in italic or two words in italic, non italic words follows.
For example:

word1 word2 Word3 [rest of text]
word4 Word5 [rest of text]
word6 Word7 [rest of text]

What I need to do is to transform this text in a table where
- the first column will always contain the first word
- the second column will either contain the second word in italics, if this is present, or will be empty if a second word in italic is not present
- the third column will always contain the first word not in italic (which can be the second or the third word on the line

I was hoping to do this with a clever combination of find and replace, but I did not succeed.
My knowledge of VBA applied to word is next to zero, so I ask for some assistance.

One idea I had is to select rows starting with only one word in italics, and apply a particular find and replace condition only on those. In this way I think I can correctly place the special characters that I will be use to part the columns of the table.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
from text to table, with conditions depending on format Format tab leader in “Table of figures” separate from text? WTR_girl12 Word 1 09-03-2015 10:48 AM
from text to table, with conditions depending on format How to Subtract value in table, based on two different conditions nitemath2 Excel 1 06-19-2015 01:28 AM
Hyperlink Format varies, depending on whether Target file was saved or unsaved on Hyperlink Copy RichardDavey Word 0 05-26-2015 05:26 PM
Help - Run-time error 91 - VBA for inserting and formatting text depending on style mtrborges Word VBA 2 02-08-2015 11:35 PM
3x1 Table: text in fields loses paragraph format when being bulleted madasco Word 3 06-07-2013 06:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft