Posted to microsoft.public.excel.programming

Saintsman

external usenet poster

Posts: 81

Concatenate text from columns

How can I concatenate text in colB?
ColA has 2 markers C and *
Whenever C is followed by * I need to unite the text fields in ColB
So, for the data below I want
ColA ColB
C Text1 Text1a
C Text2 Text2a Text2b Text2c

ColA ColB
C Text1
* Text1a cont'd
C Text2
* Text2a cont'd
* Text2b cont'd
* Text2c cont'd
C Text3

Hope this makes sense!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
combining columns and using concatenate	Donna[_2_]	Excel Worksheet Functions	5	April 21st 10 12:46 AM
CONCATENATE TWO COLUMNS	The Cable Guy	Excel Worksheet Functions	3	December 16th 09 04:37 AM
Concatenate two columns?	uma	Excel Worksheet Functions	1	April 19th 06 09:46 AM
Concatenate 3 columns.	Jim15[_12_]	Excel Programming	0	February 23rd 06 05:08 PM
Concatenate 3 columns.	Jim15[_13_]	Excel Programming	0	February 23rd 06 05:00 PM

All times are GMT +1. The time now is 08:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us