Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I use Excel to create this text file?
I'm trying to use Excel to generate a simple script text file but can't seem
to get it right. The file follows a fixed repeating pattern like the one shown below and I'm trying to get Excel to insert a line from a list (A1, A2, A3 etc) in the third line of the repeating pattern. This is the type of file I'm trying to create: Fixed line 1 Fixed line 2 Cell Info A1 Fixed line 3 Fixed line 1 Fixed line 2 Cell Info A2 Fixed line 3 Fixed line 1 Fixed line 2 Cell Info A3 Fixed line 3 Excel doesn't seem to be able to repeat this type of pattern unless maybe there's a setting I can change. Hope somebody can help with this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create web pages from excel file? | Excel Discussion (Misc queries) | |||
How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |