Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting text into Excel

Status
Not open for further replies.

gaylec54

Technical User
Apr 15, 2008
15
US
First-time poster here...

Is it possible to insert text from a Word file into Excel, similar to the "insert text from file" command in Word?

Thanks!
 
Can you elaborate a little?
[OL]
[LI]Where is the "insert text from file" option in Word?[/LI]
[LI]What sort of text are you needing to import? Is it in a table format, or just a paragraph, or what?[/LI]
[LI]Is this a one time thing, or something you'll need to do on an ongoing basis?[/LI]
[/OL]

--

"If to err is human, then I must be some kind of human!" -Me
 
1. In Word, it's here: Insert > Object > Text from file...

2. It's a paragraph, or a short description. This will only need to be placed in one cell. Other imported text will be placed in other cells, as needed.

3. It will be an ongoing thing.

Thanks!
 
[OL]
[LI]What version of Word? I have Word 2003, and did not see such an option. It goes Insert -> Object then opens to a prompt where you choose the type of object, or browse for the file. I tried selecting a text file, and it basically gave something like an image place holder for the text file.[/LI]
[LI]If it is something short, then just a simple copy/paste should work fine, right? Just adjust the cell size, set wrapping, etc, and that should do it.[/LI]
[LI]Depending upon how complex the option is, and how frequent, you might want to consider using some VBA programming to get it done. Or if it is the same text used in multiple workbooks/worksheets, then you could create a template with the text already there, and use that template going forward.[/LI]
[/OL]

--

"If to err is human, then I must be some kind of human!" -Me
 
1. Sorry -- it's Office 2007.

2. We may have to copy and paste, if necessary, but I'm trying to standardize the workflow for the users in my department. They use the "insert text" option for including blocks of text in Word, so I was trying to do the same thing in Excel, to keep things simpler for them. I've just completed their transition from WordPerfect to Word for their documents, so I'm trying not to jolt their sensibilities too much by changing everything at once! LOL...

3. There are over 100 different text blocks that can be inserted into their reports. We do have a set of standardized documents that form the base for the reports, but each job has a unique combination of items in it. We do a lot of custom work, so the inserts are added as necessary to identify and describe different items available for that particular job.

I'm not any sort of programmer -- I'm actually a desktop publisher. I'm not terribly expert in Word or Excel, but can usually get by OK with the knowledge I have. This particular request as sort of stumped me, and after looking on Microsoft's website all morning, I thought I'd ask the REAL experts who use it all the time.

Thanks for your reply...
 
Well, it would be possible to fix up a button in Word or Excel that does the copying for you, using VBA programing. If you wanted to figure out how to at least get started, in Excel, you can go to Tools ->Macro ->Record new macro, and do a copy, then paste, and then stop recording. Feel free to do other things.

Then you can go to Tools ->Macro -> Visual Basic Editor, and it should pop right up to the code from that event. It'll say something about macro recorded by (your name/login) in green text most likely, and you'll see the code that does the work below that.

Also, in VBA, at least, there are a lot of helps built in where you type. For instance, if you type DoCmd., then right after you type the period, you should get a context menu showing you all the possible options. Especially for basic things, this is GREAT!

Anyway, take a look. You could end up making it simpler even than it was before. [wink]

--

"If to err is human, then I must be some kind of human!" -Me
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top