Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Import plain text with formulas into Excel
I'm having some trouble in Excel. If I create a plain text file like the following: 1,2,3 4,5,6 =sum(a1:a2), =sum(b1:b2) Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and so on. This really sucks as I can't just install other software on the server nor make other modifications. I don't know what Microsoft was thinking when they translated the versions; any Excel version should accept it's language commands and English commands, but well, that's too much to ask for... Any good sugestions? Regards -- schmiedel ------------------------------------------------------------------------ schmiedel's Profile: http://www.excelforum.com/member.php...o&userid=28086 View this thread: http://www.excelforum.com/showthread...hreadid=475927 |
#2
|
|||
|
|||
Read the text file and parse it yourself.
When you find a value that looks like a formula (starts with an equal sign??), you can process that string special. Chip Pearson has some code at: http://www.cpearson.com/excel/imptext.htm It looks to me like there would be one line to change: Cells(RowNdx, ColNdx).Value = TempVal becomes Cells(RowNdx, ColNdx).Formula = TempVal But be a little careful. If your text strings contain commas: =if(a1="",a1+3,a1^2) You'll have to parse that as one string. schmiedel wrote: I'm having some trouble in Excel. If I create a plain text file like the following: 1,2,3 4,5,6 =sum(a1:a2), =sum(b1:b2) Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and so on. This really sucks as I can't just install other software on the server nor make other modifications. I don't know what Microsoft was thinking when they translated the versions; any Excel version should accept it's language commands and English commands, but well, that's too much to ask for... Any good sugestions? Regards -- schmiedel ------------------------------------------------------------------------ schmiedel's Profile: http://www.excelforum.com/member.php...o&userid=28086 View this thread: http://www.excelforum.com/showthread...hreadid=475927 -- Dave Peterson |
#3
|
|||
|
|||
This line doesn't apply:
When you find a value that looks like a formula (starts with an equal sign??), you can process that string special. I looked at Chip's code after I wrote that and should have deleted that sentence. Dave Peterson wrote: Read the text file and parse it yourself. When you find a value that looks like a formula (starts with an equal sign??), you can process that string special. Chip Pearson has some code at: http://www.cpearson.com/excel/imptext.htm It looks to me like there would be one line to change: Cells(RowNdx, ColNdx).Value = TempVal becomes Cells(RowNdx, ColNdx).Formula = TempVal But be a little careful. If your text strings contain commas: =if(a1="",a1+3,a1^2) You'll have to parse that as one string. schmiedel wrote: I'm having some trouble in Excel. If I create a plain text file like the following: 1,2,3 4,5,6 =sum(a1:a2), =sum(b1:b2) Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and so on. This really sucks as I can't just install other software on the server nor make other modifications. I don't know what Microsoft was thinking when they translated the versions; any Excel version should accept it's language commands and English commands, but well, that's too much to ask for... Any good sugestions? Regards -- schmiedel ------------------------------------------------------------------------ schmiedel's Profile: http://www.excelforum.com/member.php...o&userid=28086 View this thread: http://www.excelforum.com/showthread...hreadid=475927 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formulas to create large blocks of text | Excel Discussion (Misc queries) | |||
How do I import several text files into excel or access ? | Excel Discussion (Misc queries) | |||
Where is text to speech in excel 2003? | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Excel Text import wizard | Excel Discussion (Misc queries) |