FILES made of cells

  • Thread starter Thread starter RealInfo
  • Start date Start date
R

RealInfo

Hi
How do I make a text file which every line in it is composed of several
cells like

line 1> C1 +' '+ D1 + ' ' + F1 etc
line2 > C2 .....F2

How do I generate that var that will be writen to the text file line by line

Thanks
EC
 
Insert a new worksheet in the file, and in A1 of this worksheet enter
this formula:

=Sheet1!C1&" "&Sheet1!D1&" "&Sheet1!E1&" "&Sheet1!F1

Copy this down as required.

When doing File | Save As with this new sheet selected, change the
File type to Text (*.txt), and it will only save the current sheet in
that text format.

Hope this helps.

Pete
 
Back
Top