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

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


--
NorcalTruck
------------------------------------------------------------------------
NorcalTruck's Profile: http://www.excelforum.com/member.php...o&userid=29906
View this thread: http://www.excelforum.com/showthread...hreadid=496101

What you can do is use a helper column to combine "AUTO:" and your part
number, in your example you're using column A so what you would do is
select column A then go to Insert/Columns, now starting in the first
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 by
going to Edit/Paste Special and selecting "Value"....you can now delete
the helper column.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496101

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 SpecialValues (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

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

Brian
Http://www.norcaltruck.com


--
NorcalTruck
------------------------------------------------------------------------
NorcalTruck's Profile: http://www.excelforum.com/member.php...o&userid=29906
View this thread: http://www.excelforum.com/showthread...hreadid=496101