| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy String to the Right of "hyphen"
I have a column of data that includes a product name along with a code for a
particular container type. The name and code are separated by a hyphen. For example AB1222-10, AB1222-330OW, AB1222-330OWPCFL. As you can see, the string to the right of the hyphen varies in length and it can be either alpha, numeric, or a mix. How can I generate a column that contains only the text to the right of the hyphen? Example (based on above): 10, 330OW, 330OWPCFL as cell values in the column. Thank you.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
| Copy a string text to cell if another cell not empty | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Updating master workbook from source that may/may not exist | Excel Worksheet Functions | |||
| how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) | |||
Threaded Mode
