LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 90
Default Need to seperate

Okay I am doing something wrong here.


I have a little over 350 lines of information that look something like this:

001 - ROTOR WILL NOT TURN

I need to split the 001 from ROTOR WILL NOT TURN and get rid of the hyphen
altogther.

The problem is not all 001's are the same length, for instance, it could be
R05C22 TOTAL HUMAN-COMBUSTION.

So, I can't do a fixed width because it cuts out some of the data and the
other way seperates every hyphen.

I want it to look like this:


A B
1 001 ROTOR WILL NOT TURN

2 R05C22 TOTAL HUMAN-COMBUSTION

 
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 do I seperate a full name field out into three seperate columns? Rod Excel Worksheet Functions 3 October 31st 06 08:06 PM
seperate first 2 lines of column in seperate columns in same row Glynnhamer Excel Discussion (Misc queries) 2 October 9th 06 04:23 AM
How do I seperate data from a pivot into seperate worksheets? Shannon Excel Discussion (Misc queries) 5 August 25th 05 06:07 AM
how do i seperate data from one column into two seperate ones in . Nikki Excel Discussion (Misc queries) 2 March 30th 05 08:31 PM
Seperate First and Last Name into different cells Sam555 Excel Worksheet Functions 5 March 11th 05 06:17 AM


All times are GMT +1. The time now is 11:28 AM.

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"