Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy and paste formula ASU Excel Discussion (Misc queries) 0 August 29th 06 01:19 AM
Paste formula every nth row edinclimb Excel Discussion (Misc queries) 1 January 2nd 06 11:52 PM
why cant I copy and paste a formula? Bryan J Bloom Excel Discussion (Misc queries) 2 November 25th 05 02:47 PM
formula cut and paste Bryan J Bloom Excel Worksheet Functions 3 November 3rd 05 01:38 PM
Paste Formula Spikesmom Excel Discussion (Misc queries) 1 June 6th 05 04:20 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"