Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2022, 07:26 AM
JohanBouva JohanBouva is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2019
Novice
how do I place text from an excel column in a default template
 
Join Date: Jun 2022
Posts: 5
JohanBouva is on a distinguished road
Talking how do I place text from an excel column in a default template

I am trying to place it in a default word document with an excel sheet from a column of text.


Who has a solution for this?
I am a beginner with Exel and Words
Reply With Quote
  #2  
Old 06-29-2022, 10:17 AM
Charles Kenyon Charles Kenyon is offline how do I place text from an excel column in a default template Windows 11 how do I place text from an excel column in a default template Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I think you mean a default blank document. You do not want any text in the default Normal template.


Copy and paste?


Do you want an Excel spreadsheet part in your Word document?
Do you want the text that is in the column?


What end result are you looking for?


See also Mail Merge and Use mail merge for bulk email, letters, labels, and envelopes - Office Support
Reply With Quote
  #3  
Old 06-29-2022, 01:57 PM
kilroyscarnival kilroyscarnival is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by JohanBouva View Post
I am trying to place it in a default word document with an excel sheet from a column of text.
Who has a solution for this?
I am a beginner with Exel and Words

Johan, you may want to play around with the different options for pasting Excel cells into Word. First, do you need to create a link to the Excel sheet so that if/when the data changes in Excel, you can update it into Word? I'm guessing not since you say it's text, but you do have that option. Do you want it to just be text, or become a table?

See attached picture that shows the six things that pop up for me in Word 365. I'm guessing that either option 2 (use destination styles) or 6 (keep text only) might be what you're looking for, but you can copy your cells in Excel, go to your Word document, and right mouse click. You should see those paste options. You can try all six, one by one, and just Undo (CONTROL + Z keyboard shortcut) to go back and try the next one. As you mouse over those icons it will show you what they do.

Ann
Attached Images
File Type: jpg paste-excel-cells-into-word.jpg (55.8 KB, 27 views)
Reply With Quote
  #4  
Old 06-30-2022, 01:48 AM
JohanBouva JohanBouva is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2019
Novice
how do I place text from an excel column in a default template
 
Join Date: Jun 2022
Posts: 5
JohanBouva is on a distinguished road
Default

thanks gentlemen for your contribution.
Maybe I wasn't clear enough.
This is what have.
I make Quick Solution Cards for my company.
the card describes a problem solution for the customer on one A4 .

the problem is visible to the customer on a screen via key words .

Now I have made a default template in words where I only have to insert the key words and save it
I made a pivot table for all the problem reports.

in the pivot table I linked each problem message to the relevant word file.

My question is:
Can I call up the default word template with a click on the keywords alarm message in the pivot table and where the keywords are inserted in the right place in the word document?
Sorry for the long explanation.
Reply With Quote
  #5  
Old 06-30-2022, 04:49 AM
Charles Kenyon Charles Kenyon is offline how do I place text from an excel column in a default template Windows 11 how do I place text from an excel column in a default template Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Did you look at the links I provided?
Reply With Quote
  #6  
Old 06-30-2022, 05:02 PM
Guessed's Avatar
Guessed Guessed is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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

It sounds like you will need a macro to do this. You will need to post a sample Excel workbook and Word document (template) showing what you have currently. If it is clear where the keywords are and where they need to go then someone may be able to create the macro for you.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 07-04-2022, 05:12 AM
JohanBouva JohanBouva is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2019
Novice
how do I place text from an excel column in a default template
 
Join Date: Jun 2022
Posts: 5
JohanBouva is on a distinguished road
Default

Hello Charles.

I have looked at your Links , but this is not what i am looking for.
Thanks for the answer.
Reply With Quote
  #8  
Old 07-06-2022, 06:03 AM
JohanBouva JohanBouva is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2019
Novice
how do I place text from an excel column in a default template
 
Join Date: Jun 2022
Posts: 5
JohanBouva is on a distinguished road
Default How do I place text from anexecl column in a default word template

These are the Word templates and exel seartch document .
I hope it makes things clear .
Attached Files
File Type: xlsx Test example.xlsx (20.0 KB, 10 views)
Reply With Quote
  #9  
Old 07-06-2022, 11:17 PM
macropod's Avatar
macropod macropod is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There is no Word document attached to your post.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 07-12-2022, 03:57 AM
Guessed's Avatar
Guessed Guessed is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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

Johan

Your question is still not clear. Your Excel file contains phrases and no connection to Word templates/files. It is not clear how you expect any of this to work. You posted an unrelated Word document to me which doesn't help at all.

You will need to describe clearly how a 'user' will interact with your Excel and Word documents or provide examples that relate directly to the question you asked if you want help.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #11  
Old 07-12-2022, 12:16 PM
kilroyscarnival kilroyscarnival is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

So, when you click on the description in column B, you want it to open a Word file?

You can probably do this using hyperlinks. If the documents are all in a common shared drive/folder or on the web, you can make the Excel a hyperlink to that file.
Attached Files
File Type: xlsx Test example-2.xlsx (20.8 KB, 6 views)
Reply With Quote
  #12  
Old 07-14-2022, 06:33 PM
Guessed's Avatar
Guessed Guessed is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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 that is a great suggestion from kilroyscarnival.

The keywords in your spreadsheet are really phrases so there isn't any point in trying to build a database and do a bunch of coding when people can just jump straight to the file with a non-code solution.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #13  
Old 07-20-2022, 02:10 AM
JohanBouva JohanBouva is offline how do I place text from an excel column in a default template Windows 10 how do I place text from an excel column in a default template Office 2019
Novice
how do I place text from an excel column in a default template
 
Join Date: Jun 2022
Posts: 5
JohanBouva is on a distinguished road
Default

Hello Kilroyscarnival >

I have try your example files and they work form me .
Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I place text from an excel column in a default template Changing my Excel 2010 Blank/Default Template revmwilson8 Excel 1 08-09-2016 02:57 AM
how do I place text from an excel column in a default template Excel Default Template kneghx Excel 1 05-13-2015 09:29 AM
how do I place text from an excel column in a default template editing a number/text at one place and changes taking place wherever it appears anurag.butoliya Word 1 06-14-2014 06:27 PM
Excel 2010 default column width 8.09 Jeff_J Excel 0 05-28-2013 11:56 AM
Can you place an Excel Template in the Public Folders gfkbob Outlook 0 01-09-2010 08:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft