Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Inserting text from external file into cells.

I need to enter text data from another excel file into column D, the rows in
columns A through column C are as follows:
R1 Header
R2 text
R3 DATE
R4 Empty
R5 text
I need to be able to insert the text into Column D R3 & R4 in the first
instance and then reduce the Row count by 1 as the header is not part of the
text data after the first insert.

The next insert would be into Row 7 & row 8 of Column D all the way down to
R41
column D
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting an Item into cells with text Dolfan13net Excel Worksheet Functions 2 December 8th 07 05:41 AM
Inserting text into numerous cells for many different files joshua Excel Discussion (Misc queries) 4 December 29th 06 06:09 PM
Inserting line breaks into merged text cells. MrSafetyNeedshelp Excel Discussion (Misc queries) 1 August 11th 05 10:12 PM
How can you import external text file paragraph a into single cell Sam Excel Discussion (Misc queries) 0 April 14th 05 12:58 PM
External link only works for numbers -- for text values, #N/A is displayed unless linked file is open Sven Filter Links and Linking in Excel 1 February 22nd 05 08:10 AM


All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"