Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I append same text to all the cells in a column at once? | Excel Worksheet Functions | |||
Append value to cell or cells | Excel Discussion (Misc queries) | |||
Append value to cell or cells | Excel Discussion (Misc queries) | |||
How do I append data in several cells in one column | Excel Discussion (Misc queries) | |||
append 2 cells, delete old | Excel Programming |