Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-25-2024, 07:19 AM
WJSwanepoel WJSwanepoel is offline Converting tables to text Windows 10 Converting tables to text Office 2021
Advanced Beginner
Converting tables to text
 
Join Date: Dec 2019
Location: Krugersdorp, South Africa
Posts: 82
WJSwanepoel is on a distinguished road
Default Converting tables to text

I have a large number of two column tables that I wish to convert to text in Word 365.


However, I do not want the conversion to worry about rows.
I need the entire first column of the table to be followed by the entire 2nd column.

Is there a way to do this?
Reply With Quote
  #2  
Old 07-28-2024, 12:12 AM
Guessed's Avatar
Guessed Guessed is offline Converting tables to text Windows 10 Converting tables to text Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,163
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I think I would cut the second column and paste it below the first column, and then convert to text.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 07-28-2024, 08:32 PM
WJSwanepoel WJSwanepoel is offline Converting tables to text Windows 10 Converting tables to text Office 2021
Advanced Beginner
Converting tables to text
 
Join Date: Dec 2019
Location: Krugersdorp, South Africa
Posts: 82
WJSwanepoel is on a distinguished road
Default Thank yoy!

Hi Andrew,
How absolutely dumb of me not to think of such a simple solution!
I was just hoping for a VBA solution, because there are quite a large number of these tables (in excess of a 100.

Regards,
Willem
Reply With Quote
  #4  
Old 07-29-2024, 12:52 AM
Guessed's Avatar
Guessed Guessed is offline Converting tables to text Windows 10 Converting tables to text Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,163
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You could try this bodgy code
Code:
Sub TableDeconstructor()
  Dim i As Integer, aRng As Range
  For i = ActiveDocument.Tables.Count To 1 Step -1
    With ActiveDocument.Tables(i)
      If .Columns.Count > 1 Then
        .Columns(2).Select
        Selection.Cut
        Set aRng = .Range
        aRng.Collapse Direction:=wdCollapseEnd
        aRng.Select
        Selection.Paste
        .ConvertToText
      End If
    End With
  Next i
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 07-29-2024, 03:04 AM
WJSwanepoel WJSwanepoel is offline Converting tables to text Windows 10 Converting tables to text Office 2021
Advanced Beginner
Converting tables to text
 
Join Date: Dec 2019
Location: Krugersdorp, South Africa
Posts: 82
WJSwanepoel is on a distinguished road
Default Thanks!

Thanks a million, will give it a go.
Reply With Quote
Reply

Tags
table, text



Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting tables to images - landscape issue. arabgogs Word VBA 0 07-19-2024 02:04 AM
Converting tables to text Multiple tables in Word, converting working Excel macro ez1138 Word VBA 5 04-14-2021 04:39 AM
Converting tables to text Converting plain text to text box/frame peacespotting Word 1 08-08-2013 10:39 PM
converting arabic text pdf to word messes up text jeffk Word 0 10-20-2012 10:01 AM
Converting tables to text converting picture into text MS Office Noob Word 2 06-12-2012 05:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 AM.


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