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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> 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
 
 
Start new topic
Replies
MadPiet
post May 16 2019, 04:00 PM
Post#2



Posts: 3,207
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,207
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
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    21st August 2019 - 07:17 AM