|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Word table - how do I append % symbol to each value in columns 3 & 4 of a table
The table forms part of a progress report and the values in columns 3 and 4 are pasted in from another programme, reporting on the planned vs actual percentage of task completion.
I have had to go through each cell and manually copy/paste the % symbol to the end of each value. The table is quite small just now, but the macro will save me a lot of time when the project progresses and additional tasks are added. I hope to be able to edit the macro myself to include text formatting. Regards Dawsie |
#2
|
||||
|
||||
Hi Dawsie,
You can do that by selection the columns and using a wildcard Find/Replace, where: Find = <[0-9.,]{1,}> Replace = ^&%
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks Macropod, this is exactly what I'm looking for and saves a bit of time messing about with code.
|
#4
|
|||
|
|||
… or add % to the column header and leave the imported data as it is ;-}
|
#5
|
||||
|
||||
One could, but that's not what was asked for (many publishers prefer to include the symbols in-line so as to provide rapid visual cues as one's eyes move away from the headings) and the solution is quite easily implmented.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Word table based on another table input | mpdsal | Word VBA | 10 | 10-29-2012 07:40 AM |
Making Table from Text with Many Columns | SQLUSA | Word | 14 | 07-31-2012 04:26 AM |
How to sort table having three columns? | Bahir Barak | Word | 2 | 01-20-2011 01:52 PM |
Resize-to-fit Table Columns (PowerPoint) | icu222much | PowerPoint | 0 | 06-06-2010 11:21 AM |