Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Need title separated into 2 columns

Instead of the jobcode being one title, need to break manangement title out
to two new columns: Title and Section with title spelled out. Is this
possible?

JOBCODE# JOBCODE Title Section
50612 Invoice Auditor
1031 VP, Field Vice President Field
1031 VP, Field
50321 Orientation Coord
50211 Exec. Asst.
10461 Dir., Northern Division Director Northern Division
4011 Region Mgr Manager Region
10219 VP, Sales
10219 VP, Sales
4011 Region Mgr
4011 Region Mgr

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Need title separated into 2 columns

Not exactly as you asked for it, but...
you can do some damage to it..

Highlight your jobcode and go to Data - Text to columns, and select delimited.

select space as your delimiter.

highlight your first title column, find VP, replace with Vice president.
Same for any other common abbreviations, Mgr to Manager, etc.

for those that break out into multiple fields, you can use concatenate..
= D2&" "&E2 would combine cells D2 and E2 with a space between them...

May have to do a few of those kinds of things, but better than the
alternative...


"Roberta" wrote:

Instead of the jobcode being one title, need to break manangement title out
to two new columns: Title and Section with title spelled out. Is this
possible?

JOBCODE# JOBCODE Title Section
50612 Invoice Auditor
1031 VP, Field Vice President Field
1031 VP, Field
50321 Orientation Coord
50211 Exec. Asst.
10461 Dir., Northern Division Director Northern Division
4011 Region Mgr Manager Region
10219 VP, Sales
10219 VP, Sales
4011 Region Mgr
4011 Region Mgr

Reply
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
How can I filter just 2 columns (separated by another column)? theglove33 Excel Worksheet Functions 2 July 29th 08 07:15 PM
Combining separated columns? RaineeDays Charts and Charting in Excel 5 April 3rd 08 03:03 AM
How to print separated, selected columns on a worksheet NavyPianoMan Excel Discussion (Misc queries) 11 August 29th 07 12:30 PM
Concatenate columns, separated by double quotes Felicia Excel Worksheet Functions 2 April 20th 05 07:48 PM
Copy/Paste of separated columns mareku Excel Discussion (Misc queries) 2 January 5th 05 11:04 PM


All times are GMT +1. The time now is 07:14 AM.

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

About Us

"It's about Microsoft Excel"