First time poster...long time Lurker! Thanks for ALL your help !!!
I have a worksheet where Column A contains my Project Numbers (text) and Column B contains the associated Project Name (text). I would like to merge or concatenate Col A and Col B and have the results in Column C. I have seen other posts that use =A1&" "&B1, but that only returns the merge for A1 and B1. I have 80 or so rows to merge. Is there a wildcard or similar tool that would apply the merge to the entire column including all the rows?
Thanks In Advance !!!
BTW using Excel 2000 ver 9.0.****
I have a worksheet where Column A contains my Project Numbers (text) and Column B contains the associated Project Name (text). I would like to merge or concatenate Col A and Col B and have the results in Column C. I have seen other posts that use =A1&" "&B1, but that only returns the merge for A1 and B1. I have 80 or so rows to merge. Is there a wildcard or similar tool that would apply the merge to the entire column including all the rows?
Thanks In Advance !!!
BTW using Excel 2000 ver 9.0.****