UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Mail Merge, Office 2013    
 
   
Kruzer
post May 16 2019, 03:55 PM
Post#1



Posts: 413
Joined: 26-February 11
From: Nova Scotia, Canada


Version = Office 365 (not in list so I selected 2013)

In my spreadsheet, I have a column that may contain one or more abbreviations in each row/cell or the cell could be blank. In the Word document, I want to be able to change those abbreviations to their long name. I can do this if there is one abbreviation in the cell but is there a way to return all long names based on the abbreviation(s) in the cell? As well, I would like each one on their own line. Examples:

abbrev1, abbrev2 would output as:

abbreviation 1
abbreviation 2

--------------------
Cheers,
Go to the top of the page
 
MadPiet
post May 16 2019, 04:00 PM
Post#2



Posts: 3,136
Joined: 27-February 09



I think you would have to split the pieces on the delimiter, use a table to match the abbreviation to the full text, and then reassemble them. But I'm more a database person, so take that with a grain of salt.
Go to the top of the page
 
Kruzer
post May 16 2019, 04:02 PM
Post#3



Posts: 413
Joined: 26-February 11
From: Nova Scotia, Canada


If it was in a database it might be easier.

--------------------
Cheers,
Go to the top of the page
 
MadPiet
post May 16 2019, 04:13 PM
Post#4



Posts: 3,136
Joined: 27-February 09



Create database in Access,
Add linked table,
Use SPLIT() and write the results to a child table. Join Child table to translation table (abbreviation(PK), fulltext)
Query that and maybe reassemble there.
Go to the top of the page
 
Kruzer
post May 17 2019, 08:26 AM
Post#5



Posts: 413
Joined: 26-February 11
From: Nova Scotia, Canada


I already have an Access database so may try something with it. Thanks for your suggestion!

--------------------
Cheers,
Go to the top of the page
 
dflak
post May 22 2019, 02:57 PM
Post#6


Utter Access VIP
Posts: 6,283
Joined: 22-June 04
From: North Carolina


CTRL-H on the column
Substitute FullName1 for abbr1

lather, rinse, repeat for all abbreviations

then as a final touch
Substitute CHAR(10) for ,

--------------------
Dan

One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
Please zip and attach samples. It makes life easier for those who have to figure out what you are trying to do. Thanks
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    25th June 2019 - 09:44 AM