Help after doing the concatenate function

[pappy]

I have successfully combined the data that I needed to and would like to
copy the finished work into an existing spreadsheet to be imported
into my QuickBooks program. But, when I try to copy the cells and
paste them I get the concatenate
formula(=CONCATENATE(A1,B1,C1,D1,E1,F1)) and not the actual text.

How do I copy the data to the spreadsheet that I am using for the
import and keep the text? I am afraid that all the items (1700+lines 4
columns each) that I need to add to my QuickBooks will be lost since
the reference will not transfer to QB with the import and I will have
to do it manually.
Please help
I am using Microsoft Excel 2000 with Win XP Home

Thanks,
Pappy

 

[JMay]

Once your cell(s) formula has concatenated you need to convert to values;
by copying the Block of cells say B10:B1000 by highlighting then Ctl+C,
then without moving the cursor, Toolbar, Edit, Paste-Special, Values, OK, OK
Now your cells have been "converted" to text, available for transferring.
HTH

 

[pappy]

JMay,
I can't thank you enough. I worked perfectly and I can finish the
project.
Thanks again,
Pappy