Copying and pasting ???

[NorcalTruck]

Im working with a .iif file from quickbooks inside excel and have
question regarding copying and pasting.

Lets say for example cell A1 Says "AUTO". Well Cells A2 throught A43
need to have "AUTO:" before the part number so it shows up as a su
category in quickbooks.
Auto: 1234
Auto: 1235 and so on.
Is there a way to copy/paste "AUTO:" into the column without going int
each cell and pasting "AUTO:"....just tryin to save a little time that
all...Thank you
Bria

 

[pinmaster]

What you can do is use a helper column to combine "AUTO:" and your par
number, in your example you're using column A so what you would do i
select column A then go to Insert/Columns, now starting in the firs
row of your part number type:
="Auto: "&A1
then copy down as far as needed.
A1 being your first row with a part number

Once that's done copy your data from the helper column into column A b
going to Edit/Paste Special and selecting "Value"....you can now delet
the helper column.

HTH
J

 

[Ken Johnson]

Hi Brian,
In a spare column Type "Auto: " (without the speech marks).
Copy this down (Fill down) the spare column as far as needed.
In another spare column type an equals sign "=" (without the speech
marks), then click in the top cell with "Auto: " then shift 7 to get
the "&", then click in the top cell with the number (eg 1234), then
press Enter. That cell should now show "Auto: 1234" (or whatever number
it happens to be).
Now copy that column down as far as needed.
Select all of those cells with the completed "Auto: ####" and copy.
Click in the top cell of the column where you want these completed
alphanumeric value to finally be, then Paste Special>Values (either
from the edit menu or right click popup).

Make sure you try it out first on a backup copy, even though you can
undo any mistakes.


Ken Johnson

 

[NorcalTruck]

Thank You both for the tips....just saved me a great deal of time.

Brian
Http://www.norcaltruck.co