append 2 cells, delete old
Jim, Tom, Thanks! I was not able to figure Jim's help, but thank you for reply Probably due to me being stupid on this. Tom, I was able to use your suggestion with near perfect results. I left 0's (which I needed to delete) but I was able to remove them b using in next col: =if(a1=0,"",a1) and then copy and paste special values into the proper col and delet col with formula!! Yipee! I was also able to go through my data and record a macro of my doin each step needed so I did not have to enter formulas each time, now th formula entry has been recorded. That is way cool. Thanks for your help! All of you!! Now I just have one last hurdle. Sometimes the data is not just on tw cells in a col but in three cells. So far the formulas only work on tw cell problems. I'm trying to make it smart enough to work on 3 cells a well as two, where needed. like, I need a2,a3, and a4 combined like: a2=hello a3=my name is a4=bill to become a2=hello my name is bill but since I recorded the 2 cell process into a macro I should be abl to figure out how to apply to a 2 and 3 cell where applicable I woul think. Thanks again! I'm fairly confident I could figure this out if I coul find a macro reference online. Things are real tight and cannot affor book right now. Bil -- billbeecha ----------------------------------------------------------------------- billbeecham's Profile: http://www.excelforum.com/member.php...fo&userid=1628 View this thread: http://www.excelforum.com/showthread.php?threadid=27788 |
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com