Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
Concatenating entire columns
I have two columns of data (A and B) that are already filled up with
data. (Column A is text data and column B is numeric data). Can I create a new column (Column C) that globally concatenates values in the same row in Column A and B into C? eg my data looks like this column a column b column c AAA 111 AAA111 AAA 222 AAA222 AAA 333 Is there a way I can do this without using the concatenate function in each individual cell in Column C? Ie. do a global concatenate for column C. Thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split Text to columns using an entire word, not just a single cha | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
concatenating with unequal columns | Excel Discussion (Misc queries) | |||
Convert entire columns of text email addresses to hyperlinks | Excel Worksheet Functions |