Hi all,
Assume Cell B1 is "ClassA"
Assume Cell B2 is "MayMay"
I would like to make D2 as "ClassA MayMay"
How can i do that?
I have tried to write as =B1,B2 it seems not workable~
Thanks.
Hi all,
Assume Cell B1 is "ClassA"
Assume Cell B2 is "MayMay"
I would like to make D2 as "ClassA MayMay"
How can i do that?
I have tried to write as =B1,B2 it seems not workable~
Thanks.
Use '&' to build a string of characters:
=B1&" "&B2
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
[email protected] wrote:
> Hi all,
>
> Assume Cell B1 is "ClassA"
> Assume Cell B2 is "MayMay"
>
> I would like to make D2 as "ClassA MayMay"
>
>
> How can i do that?
> I have tried to write as =B1,B2 it seems not workable~
>
> Thanks.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks