If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text to Columns
500+ sentences, I need to seperate (text to columns) after the first "-"
only. There are subsequent "-" but I only want it seperated at the first. And when I seperate it in the second column I do not want a space preceeding the text. Can you give advice on this, any help would be much appreciated! Thanks Sample Data AIR TAXI - An aircraft operator who conducts operations for hire or compensation in accordance with FAR Part 135 in an aircraft with 30 or fewer passenger seats and a payload capacity of 7,500# or less. An air taxi operates on an on-demand basis and does not meet the "flight scheduled" qualifications of a commuter. AIR TRAFFIC CONTROL (ATC) - A service operated by the appropriate authority to promote the safe, orderly, and expeditious flow of air traffic. AIRPORT TRAFFIC CONTROL TOWER (ATCT) - A terminal facility that uses air/ground communications, visual signaling, and other devices to provide ATC services to aircraft operating in the vicinity of an airport or on the movement area. Authorizes aircraft to land or takeoff at the airport controlled by the tower or to transit the Class D airspace area regardless of flight plan or weather conditions (IFR or VFR). A tower may also provide approach control services (radar or non-radar). ALCLAD - Trademark name of Alcoa for high-strength sheet aluminum clad with a layer (approximately 5.5% thickness per side) of high-purity aluminum, popularly used in airplane manufacture. ALPHABET (PHONETIC) - Devised for reasons of clarity in aviation voice radio, this is the current NATO version in global use: |
#2
|
|||
|
|||
Text to Columns
See your other post.
Fred "LeisaA" wrote in message ... 500+ sentences, I need to seperate (text to columns) after the first "-" only. There are subsequent "-" but I only want it seperated at the first. And when I seperate it in the second column I do not want a space preceeding the text. Can you give advice on this, any help would be much appreciated! Thanks Sample Data AIR TAXI - An aircraft operator who conducts operations for hire or compensation in accordance with FAR Part 135 in an aircraft with 30 or fewer passenger seats and a payload capacity of 7,500# or less. An air taxi operates on an on-demand basis and does not meet the "flight scheduled" qualifications of a commuter. AIR TRAFFIC CONTROL (ATC) - A service operated by the appropriate authority to promote the safe, orderly, and expeditious flow of air traffic. AIRPORT TRAFFIC CONTROL TOWER (ATCT) - A terminal facility that uses air/ground communications, visual signaling, and other devices to provide ATC services to aircraft operating in the vicinity of an airport or on the movement area. Authorizes aircraft to land or takeoff at the airport controlled by the tower or to transit the Class D airspace area regardless of flight plan or weather conditions (IFR or VFR). A tower may also provide approach control services (radar or non-radar). ALCLAD - Trademark name of Alcoa for high-strength sheet aluminum clad with a layer (approximately 5.5% thickness per side) of high-purity aluminum, popularly used in airplane manufacture. ALPHABET (PHONETIC) - Devised for reasons of clarity in aviation voice radio, this is the current NATO version in global use: |
#3
|
|||
|
|||
Text to Columns
"Fred Smith" wrote: See your other post. Fred "LeisaA" wrote in message ... 500+ sentences, I need to seperate (text to columns) after the first "-" only. There are subsequent "-" but I only want it seperated at the first. And when I seperate it in the second column I do not want a space preceeding the text. Can you give advice on this, any help would be much appreciated! Thanks Sample Data AIR TAXI - An aircraft operator who conducts operations for hire or compensation in accordance with FAR Part 135 in an aircraft with 30 or fewer passenger seats and a payload capacity of 7,500# or less. An air taxi operates on an on-demand basis and does not meet the "flight scheduled" qualifications of a commuter. AIR TRAFFIC CONTROL (ATC) - A service operated by the appropriate authority to promote the safe, orderly, and expeditious flow of air traffic. AIRPORT TRAFFIC CONTROL TOWER (ATCT) - A terminal facility that uses air/ground communications, visual signaling, and other devices to provide ATC services to aircraft operating in the vicinity of an airport or on the movement area. Authorizes aircraft to land or takeoff at the airport controlled by the tower or to transit the Class D airspace area regardless of flight plan or weather conditions (IFR or VFR). A tower may also provide approach control services (radar or non-radar). ALCLAD - Trademark name of Alcoa for high-strength sheet aluminum clad with a layer (approximately 5.5% thickness per side) of high-purity aluminum, popularly used in airplane manufacture. ALPHABET (PHONETIC) - Devised for reasons of clarity in aviation voice radio, this is the current NATO version in global use: . New to this. Not understanding??? |
#4
|
|||
|
|||
Text to Columns
"LeisaA" wrote: "Fred Smith" wrote: See your other post. Fred "LeisaA" wrote in message ... 500+ sentences, I need to seperate (text to columns) after the first "-" only. There are subsequent "-" but I only want it seperated at the first. And when I seperate it in the second column I do not want a space preceeding the text. Can you give advice on this, any help would be much appreciated! Thanks Sample Data AIR TAXI - An aircraft operator who conducts operations for hire or compensation in accordance with FAR Part 135 in an aircraft with 30 or fewer passenger seats and a payload capacity of 7,500# or less. An air taxi operates on an on-demand basis and does not meet the "flight scheduled" qualifications of a commuter. AIR TRAFFIC CONTROL (ATC) - A service operated by the appropriate authority to promote the safe, orderly, and expeditious flow of air traffic. AIRPORT TRAFFIC CONTROL TOWER (ATCT) - A terminal facility that uses air/ground communications, visual signaling, and other devices to provide ATC services to aircraft operating in the vicinity of an airport or on the movement area. Authorizes aircraft to land or takeoff at the airport controlled by the tower or to transit the Class D airspace area regardless of flight plan or weather conditions (IFR or VFR). A tower may also provide approach control services (radar or non-radar). ALCLAD - Trademark name of Alcoa for high-strength sheet aluminum clad with a layer (approximately 5.5% thickness per side) of high-purity aluminum, popularly used in airplane manufacture. ALPHABET (PHONETIC) - Devised for reasons of clarity in aviation voice radio, this is the current NATO version in global use: . New to this. Not understanding??? Hi Fred, Sorry I'm new to this user group thing. It says at the bottom cross-post so I thought I should... Guess not. Thanks for taking the time to read my question, however I can not find did you give an answer? Thanks, so much! Leisa |
#5
|
|||
|
|||
Text to Columns
Here is the solution I posted in response to your first post:
=left(a1,find("-",a1)-2) =right(a1,len(a1)-find("-",a1)-1) The best solutions are almost always in response to the first post. Additional posts just make them more difficult to find. Regards, Fred "LeisaA" wrote in message ... "LeisaA" wrote: "Fred Smith" wrote: See your other post. Fred "LeisaA" wrote in message ... 500+ sentences, I need to seperate (text to columns) after the first "-" only. There are subsequent "-" but I only want it seperated at the first. And when I seperate it in the second column I do not want a space preceeding the text. Can you give advice on this, any help would be much appreciated! Thanks Sample Data AIR TAXI - An aircraft operator who conducts operations for hire or compensation in accordance with FAR Part 135 in an aircraft with 30 or fewer passenger seats and a payload capacity of 7,500# or less. An air taxi operates on an on-demand basis and does not meet the "flight scheduled" qualifications of a commuter. AIR TRAFFIC CONTROL (ATC) - A service operated by the appropriate authority to promote the safe, orderly, and expeditious flow of air traffic. AIRPORT TRAFFIC CONTROL TOWER (ATCT) - A terminal facility that uses air/ground communications, visual signaling, and other devices to provide ATC services to aircraft operating in the vicinity of an airport or on the movement area. Authorizes aircraft to land or takeoff at the airport controlled by the tower or to transit the Class D airspace area regardless of flight plan or weather conditions (IFR or VFR). A tower may also provide approach control services (radar or non-radar). ALCLAD - Trademark name of Alcoa for high-strength sheet aluminum clad with a layer (approximately 5.5% thickness per side) of high-purity aluminum, popularly used in airplane manufacture. ALPHABET (PHONETIC) - Devised for reasons of clarity in aviation voice radio, this is the current NATO version in global use: . New to this. Not understanding??? Hi Fred, Sorry I'm new to this user group thing. It says at the bottom cross-post so I thought I should... Guess not. Thanks for taking the time to read my question, however I can not find did you give an answer? Thanks, so much! Leisa |
Thread Tools | |
Display Modes | |
|
|