paulinetaylor
New Member
- Joined
- Mar 2, 2011
- Messages
- 3
i want to ask how to merge alpha numeric cells can anybody help thanks pauline
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cell merge
- Thread starter paulinetaylor
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Welcome to MrExcel.
Can you explain what you mean by merge please? Give an example.
Can you explain what you mean by merge please? Give an example.
Upvote
0
paulinetaylor
New Member
- Joined
- Mar 2, 2011
- Messages
- 3
<TABLE dir=ltr border=0 cellSpacing=0 cellPadding=2 width=137><TBODY><TR><TD height=19 width="50%">
I wish to merge these two cells into one
also these three into one
<TABLE dir=ltr border=0 cellSpacing=0 cellPadding=2 width=148><TBODY><TR><TD height=19 width="33%">
thanks pauline
CBC1
</TD><TD height=19 width="50%">CFK07
</TD></TR><TR><TD height=19 width="50%">CBC1
</TD><TD height=19 width="50%">CFK07
</TD></TR><TR><TD height=19 width="50%">CBC1
</TD><TD height=19 width="50%">CFK13
</TD></TR><TR><TD height=19 width="50%">CBC1
</TD><TD height=19 width="50%">CFK05
</TD></TR></TBODY></TABLE>I wish to merge these two cells into one
also these three into one
<TABLE dir=ltr border=0 cellSpacing=0 cellPadding=2 width=148><TBODY><TR><TD height=19 width="33%">
1996
</TD><TD height=19 width="33%">to
</TD><TD height=19 width="35%">2002
</TD></TR><TR><TD height=19 width="33%">2003
</TD><TD height=19 width="33%">to
</TD><TD height=19 width="35%">on
</TD></TR><TR><TD height=19 width="33%">1997
</TD><TD height=19 width="33%">to
</TD><TD height=19 width="35%">2001
</TD></TR><TR><TD height=19 width="33%">1990
</TD><TD height=19 width="33%">to
</TD><TD height=19 width="35%">2001
</TD></TR><TR><TD height=19 width="33%">1991
</TD><TD height=19 width="33%">to
</TD><TD height=19 width="35%">1998
</TD></TR><TR><TD height=19 width="33%">1991
</TD><TD height=19 width="33%">to
</TD><TD height=19 width="35%">1998
</TD></TR></TBODY></TABLE>thanks pauline
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
You can use a formula like:
=A1&A2
=A1&A2
Upvote
0
paulinetaylor
New Member
- Joined
- Mar 2, 2011
- Messages
- 3
THANK YOU ANDREW
By adding in " I have also managed to get the spaces that I need.
Many thanks for all of your help.
Kind regards Pauline
By adding in " I have also managed to get the spaces that I need.
Many thanks for all of your help.
Kind regards Pauline
Upvote
0
Similar threads
- Question
