Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to Concatenate
Hi All, I go an excel with data in this format (3 columns): LAST_NAME FIRST_NAME Selections Adcock Julia Do Adcock Julia Ra Adcock Julia Me Aiple Matthew Do Aiple Matthew Ra I want to concatenate the third column like this for each person (to the existing sheet above) LAST_NAME FIRST_NAME Selections Adcock Julia Do, Ra, Me Aiple Matthew Do, Ra I know that this is done by conditional formating - but I have never used this before. Would anyone have any ideas? Is this a difficult task to do in excel? Thanks, James. -- hamster ------------------------------------------------------------------------ hamster's Profile: http://www.excelforum.com/member.php...o&userid=28706 View this thread: http://www.excelforum.com/showthread...hreadid=483903 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to concatenate adjacent cells in a range without using &? | Excel Worksheet Functions | |||
Concatenate | Excel Discussion (Misc queries) | |||
Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
space between text strings with concatenate | Excel Discussion (Misc queries) | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) |