MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to import formula listing

Posted by Tim McPike on January 18, 2001 10:55 AM

I've downloaded an excel code listing (a text file) from an internet site that looks like this:

{Cell A1}= B3*1.25
{Cell A2)= C3 /7

Is there a way to auto import these formulas into Excel (i.e., to not have to manually cut and paste the formulae into each listed cell)?

Is this some type of VBA code? What?


Posted by Dave Hawley on January 18, 2001 6:26 PM

Hi Tim

Have you tried Data>Text to Columns ?


OzGrid Business Applications

Posted by Tim McPike on January 19, 2001 6:50 AM

Dave! Thanks. Brilliant and simple!!!