| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
String Manipulation
I have data imported from accounting software that I'm working with. What I
need is to have a column that diplays just the length of the part off the end of the description. Lengths are in formats like 20-1/4, 4, 5-1/4. They are always preceded by one or more spaces and are always at the end of the description. Can anyone help? Following are two examples of descriptions 06530FB0325_SP MDP REC PCH 155 3-1/4 12810FB46_SP MDP LO STD PCH 155 46 Q5478MB/W075_DPBSP REC RAL6027 155 7-1/2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to do a fancy string copy plus | Excel Discussion (Misc queries) | |||
| Looking up a string of text within a string of text | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Threaded Mode
