formula or vba to cut and paste
Tax Prep ammended: Wuco, Lisa Tax
Tax Preparation Tax Prep: 2005and 2006 Lopez, belinda 0 0 Tax Prep: Abbey, Melanie 0 0 Tax Prep: Auble, Brandi finish return Tax Tax Preparation Tax Prep: Bennett, Nicholas & Heather Tax Tax Preparation Tax Prep: Boothe, Edwina 0 0 Tax Prep: Buchanan, Christa Tax Tax Preparation RS Services: child supp docs Bkpg Bookkeeping:Hourly RS Services: filling out child sup docs P/R 0 RS services: filling out p/r tax coupons P/R Payroll:Tax Deposits RS services: finish Pr P/R Payroll:W13 RS services: finish Pr P/R Payroll:Tax Deposits RS Services: make up P/R coupons P/R 0 RS services: payroll summaries P/R 0 RS Services: printed P/R summary P/R 0 these columns are in excel a2 to b2 and c2. on the top part i would like to take and cut Tax Prep: and paste it where the 0 are and not do it if Tax preparation is already their. on the second part RS Services: everything the the right of : i would like to cut and paste on the end of what is in the C column and have the : removed form column a hope fully put them in column c. so thing will look like Left Justified Center justified Center justified RS Service Bkpg Bookkeeping:Hourly:child supp docs Wuco, Lisa Tax Tax Preparation 2005and 2006 Lopez, belinda Tax Tax Prep: or if possible Tax Preparations thanks in advanced Gary Reger -- Message posted via http://www.officekb.com |
formula or vba to cut and paste
this is gary and i am sorry column c wrapped down to the next line and is all
messed up. dont know what to do. Garyr wrote: Tax Prep ammended: Wuco, Lisa Tax Tax Preparation Tax Prep: 2005and 2006 Lopez, belinda 0 0 Tax Prep: Abbey, Melanie 0 0 Tax Prep: Auble, Brandi finish return Tax Tax Preparation Tax Prep: Bennett, Nicholas & Heather Tax Tax Preparation Tax Prep: Boothe, Edwina 0 0 Tax Prep: Buchanan, Christa Tax Tax Preparation RS Services: child supp docs Bkpg Bookkeeping:Hourly RS Services: filling out child sup docs P/R 0 RS services: filling out p/r tax coupons P/R Payroll:Tax Deposits RS services: finish Pr P/R Payroll:W13 RS services: finish Pr P/R Payroll:Tax Deposits RS Services: make up P/R coupons P/R 0 RS services: payroll summaries P/R 0 RS Services: printed P/R summary P/R 0 these columns are in excel a2 to b2 and c2. on the top part i would like to take and cut Tax Prep: and paste it where the 0 are and not do it if Tax preparation is already their. on the second part RS Services: everything the the right of : i would like to cut and paste on the end of what is in the C column and have the : removed form column a hope fully put them in column c. so thing will look like Left Justified Center justified Center justified RS Service Bkpg Bookkeeping:Hourly:child supp docs Wuco, Lisa Tax Tax Preparation 2005and 2006 Lopez, belinda Tax Tax Prep: or if possible Tax Preparations thanks in advanced Gary Reger -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com