Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have the following, how can I concatenat the cells?
Row A has dup but row B does not. I need a formula that will look up row A and concatenat row B, but if row B was alread concatenated, then concatenat the next cell. e.g. ABD = AIR EXPORT / Domestic, e.g. ACS = AIR EXPORT / DOMESTIC / Ocean Export etc. ABD AIR EXPORT ABD Domestic ABO AIR EXPORT ABO Domestic ACC AIR EXPORT ACC DOMESTIC ACF IMPORT BREAKBULK ACL CMIN ACL Logistics ACS AIR EXPORT ACS DOMESTIC ACS Ocean Export ADC AIR EXPORT ADC Domestic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I insert a line break using a formula (e.g when concatenat. | Excel Worksheet Functions |