| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Sort?
With your data starting in B5, enter this formula in C5 and fill down... =RIGHT(B5,LEN(B5) -FIND(" ",B5,1)) It finds the first space and returns the text after that character. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins - two dozen ways to sort with "Special Sort") "Templar" wrote in message Below is a sample of the portion of a column on an excel sheet. I would like to put everything to the right of the number in a separate column. such as, everything to the right of 6346, 6510 and so forth and trickier ones like 7140-44 Can anyone explain to me how I would do this? Thanks. 6346 W. 13th Street 6510 W. 16th Street 6516 W. 16th Street 6519 W. 16th Street 6706 W. 16th Street 6808 W. 16th Street 7140-44 W. 16th Street 6445-10 W. 18th Street 6501 W. 18th Street 6446 W. 19th Street -snip- -- Templar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| Sort from SQL view does not sort in EXCEL | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
