| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Function for Text To Columns
I have some data that I want to extract a number from. Here is an
example. ABSD (P+3.9%) I want to get at the 3.9, and I'm assuming I would want to use the "+" sign and the "%" sign as delimiters somehow. Is there a function that would help me do this all in one step? I can get there using text to columns, but that is very manual and requires several steps. I'm out of ideas!! Thanks. -- JW |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I use IF function to compare 2 columns | Excel Discussion (Misc queries) | |||
| hiding columns or rows not using the hide function | Excel Worksheet Functions | |||
| Referencing a range of columns and rows with the IF function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| nested function to add columns | Excel Worksheet Functions | |||
Threaded Mode
