Merging Col A and Col B in Col C including blank cells

[Rashid Khan]

Hello All
I have the following problem. I am using Office XP

A B
data1 <blank>
<blank> data2
data3 <blank>
<blank> data4

I want in Col C as follows:
data1
data2
data3
data4
.......
......
The blanks can be either in Col A or Col B.. but Col C should not have a
blank

Can anyone help me on this?
TIA
Rashid Khan

 

[Paul B]

Rashid, try this in C1 and copy down =A1&B1, you can copy and paste special
valves in column C if you want just the vavles after you put this in.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[Rashid Khan]

Hi Paul,
Thanks... I had posted the reply but it is not showing so I am reposting.

Rashid Khan