Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function Help...
This hopefully is an easy one...
I have a long list of data in one column; each listing starts with a prefix that I need to remove. For example 1x4r/NAME -- I need to keep only the "Name" -- is there a way that I can remove either the first X characters and keep the remaining, or possibly remove everything after (and including) the /? The actual names are not fixed in length. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function Help...
if your data is in column A, then in next column (column B) type
=RIGHT(A1,FIND("/",A1)) Regards Philip "RH" wrote in message ... This hopefully is an easy one... I have a long list of data in one column; each listing starts with a prefix that I need to remove. For example 1x4r/NAME -- I need to keep only the "Name" -- is there a way that I can remove either the first X characters and keep the remaining, or possibly remove everything after (and including) the /? The actual names are not fixed in length. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function Help...
One way:
In an adjacent column: =MID(A1,FIND("/",A1)+1,32000) copy down as far as necessary. Copy the new column, Paste over the original column using Edit/Paste Special/Values. In article , "RH" wrote: This hopefully is an easy one... I have a long list of data in one column; each listing starts with a prefix that I need to remove. For example 1x4r/NAME -- I need to keep only the "Name" -- is there a way that I can remove either the first X characters and keep the remaining, or possibly remove everything after (and including) the /? The actual names are not fixed in length. Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function Help...
Try this:
Select your data, next go to Data/Text to columns, select "Delimited" and hit NEXT, select "Other" and type a / in the box, hit NEXT then select "Do not import column(Skip)" and hit "Finish" HTH Jean-Guy "RH" wrote: This hopefully is an easy one... I have a long list of data in one column; each listing starts with a prefix that I need to remove. For example 1x4r/NAME -- I need to keep only the "Name" -- is there a way that I can remove either the first X characters and keep the remaining, or possibly remove everything after (and including) the /? The actual names are not fixed in length. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |