Pete,

Thanks so much for the quick response. Sorry it's taken so long to reply.

Your formula is exactly what I was looking for, but it creates a new issue.
Please see my question posed in the thread above.

Thanks again for your help!

- Doug


"Pete_UK" wrote:

To have the values from A1 in Sheet1 to appear in A1 of Sheet2 (for
example), put this formula in A1 of Sheet2:

=IF(Sheet1!A1="","",Sheet1!A1)

Then you can copy this formula to other cells in Sheet2.

This will not change the format of the cell, however. You can use
TEXT(Sheet1!A1,format_string) to make some adjustments to numeric
data, or you could manipulate the values in Sheet1!A1 in some way (for
instance, if you have a date in the form 20070606 and you want it to
be in Excel's date format), but you will need to supply some further
information as to what your problem is before you can get a more
specific answer.

Hope this helps.

Pete

On Jun 7, 12:13 am, Doug wrote:
How do I copy info from one excel spreadsheet column into another using a
formula rather than use copy/paste? The original spreadsheets are in the
wrong column format and I'm trying to avoid endless copying/pasting.