How to combine 2 cells' text into 1 cell
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. |
=B1&" "&B2
-- Regards, Peo Sjoblom (No private emails please) wrote in message ups.com... 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. |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com