Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two columns of text...columns A & B
I want to combine the data in the two columns to form one column. Normally, I'd use the CONCATENATE function. However, I want to record where the join occurred without inserting extra characters. For instance, if I color the text in column A red and I color the text in column B blue; when I combine them, I'd like for the text to maintain its original color so that the first portion of the string is red, the following protion is blue. Alternatively I could do that with a font change at the join point. How could I achieve that? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete Spaces and Join Text in Cell | Excel Worksheet Functions | |||
join two spreadsheets | Excel Discussion (Misc queries) | |||
join columns, keep both values | New Users to Excel | |||
unique identifier for invoices | Excel Worksheet Functions |