View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Garyr via OfficeKB.com Garyr via OfficeKB.com is offline
external usenet poster
 
Posts: 3
Default 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