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