MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combining cells


Posted by scott on January 14, 2002 8:49 AM

Hi...I'm trying to combine info. in two different cells into one cell (different from "merge" option) In other words, in column A, I have a list of suppliers, and in Column B, I have the contacts for each. I would one column to contain both pieces of info...anybody know a way to combine these cells into one? Thanks!


Posted by Aladin Akyurek on January 14, 2002 8:58 AM

=A1&" "B1 (but why?) [NT]

Posted by Aladin Akyurek on January 14, 2002 8:59 AM

Make that: =A1&" "&B1 (but why?) [NT]