LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kiser
 
Posts: n/a
Default Concatentate Join Identifier

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Spaces and Join Text in Cell Diggsy Excel Worksheet Functions 3 October 5th 05 03:50 AM
join two spreadsheets Raya Excel Discussion (Misc queries) 1 July 14th 05 02:13 PM
join columns, keep both values FourPenny New Users to Excel 5 May 31st 05 01:36 AM
unique identifier for invoices jamboulianb Excel Worksheet Functions 1 March 16th 05 06:20 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"