Menu

splitting text in one column into multiple columns

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Flaminstar Flaminstar is offline

Flaminstar is offline

external usenet poster

Posts: 5

Default

splitting text in one column into multiple columns

Hi...Send it to . Mine didn't work quite the way I
wanted it... I need it to write in the new column what comes after the ":"
and not before (ie: not "project")....

Thanks...

"Gary Keramidas" wrote:

i have an add-in that may help. give me an address and i'll email it.

--

Gary

"Flaminstar" wrote in message
...
I have a workbook of date that I need to convert into a Pivot table/chart.
However, the headings that I need to sort on are all listed in column A. I
need to split this column into multiple columns for sorting purposes. Each
text stream in column A is starts with a "xxxxx :" ...where xxxx is
'resource', 'project', 'task', 'phase', 'activity'.
Any ideas would be greatly appreciated.
Here is a sample of the column....

Resource: Alex S
1 FTE

Project: Genesis
Task: Test Director Setup
Project: Rating
Task: Delivery
Project: Statistical Plan
Phase: Execution Phase
Project: Claims
Activity: Initiate / Plan / Execute / Closeout

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Splitting Text from single cell in column across multiple Columns	Harold	Excel Worksheet Functions	3	March 14th 10 11:06 AM
Splitting one column into multiple columns	[email protected]	Excel Worksheet Functions	8	May 2nd 06 08:01 PM
splitting 1 column of data into multiple columns	CiceroCF	Setting up and Configuration of Excel	1	March 25th 05 01:50 AM
Splitting text in one column into two (or more) columns.	RickyDee	Excel Worksheet Functions	4	December 7th 04 10:03 PM
splitting text to multiple columns	maryj	Excel Discussion (Misc queries)	5	December 1st 04 03:37 PM

All times are GMT +1. The time now is 02:10 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement