#1
|
|||
|
|||
Duplicating a column where there is no proper column delimiter
I have a long documents with pages of manual (i.e. no formatted column separator like tab, ; etc) tables.
In this table I need to duplicate a column. If someone can help me with a macro that would do this, would be greatly appreciated Example data and End result need is attached. |
#2
|
|||
|
|||
If you want help with your problem, you need to attach a Word document to your post so that the data can be seen in its original context. The pdf you attached converts the data to a table when opened in Word.
|
#3
|
||||
|
||||
If there are no tabs or spaces, what creates that white space between values?
|
#4
|
|||
|
|||
Quote:
It seems to me only relation to the formatting is the right most position of each column. Data in each column are right aligned |
#5
|
||||
|
||||
Saving to txt file then opening in Excel didn't work perfectly but it does set up data in columns.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Column issues.... Inserting text in column one moves text in column two | kita299 | Word | 3 | 01-15-2023 05:06 PM |
Auto-Entering Values into a Column in a Table based on Value in Adjacent Column | nytvsh | Excel | 2 | 12-06-2021 12:33 AM |
Formula to check combinations of values in one column to find match from another column | kong1802 | Excel | 1 | 06-15-2018 05:26 AM |
Read multiple xml files in excel - Column names and Tag - Column alignment | sumshen | Excel Programming | 0 | 04-17-2017 12:55 AM |
How can I temporarily break a 3 column format in order to type a single column paragraph | William P | Word | 1 | 01-04-2015 06:40 PM |