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
etc.

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?

Thanks


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


Hi Tim

Have you tried Data>Text to Columns ?


Dave

OzGrid Business Applications

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

Dave! Thanks. Brilliant and simple!!!