| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Column
Is there any way to separate Dollar amount to another column (last five
digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS 0545019576 LOS ANGELES CA 9.60 USPS 0545019576 LOS ANGELES CA 9.40 USPS 0545019577 LOS ANGELES CA 4.70 SHELL OIL 57442712808 UPLAND CA 16.20 VONS FUEL 10026813 UPLAND CA 26.50 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
| How to subtract one text column based on their text column MS xls. | Excel Discussion (Misc queries) | |||
| Find a text from a column in a text string within another column? | New Users to Excel | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
Threaded Mode
