| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text and numbers
You're welcome.
JBoulton wrote: Nice solution. Thanks. "Glenn" wrote: JBoulton wrote: Hi all, My text has a date, text of various length and words and a number from 0.01 to whatever. Some examples... '01/05/09 some text goes here 10,000.00 '09/01/09 or 1.05 '05/09/09 or different text like this 250.11 I'd like to create three fields. =datevalue(left(a1,8)) gets the date, but I'm stuck on the rest. Thanks for your help. Jim =--LEFT(A1,8) =MID(A1,FIND(" ",A1)+1,FIND("~",SUBSTITUTE(A1," ","~", LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-FIND(" ",A1)-1) =--RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Hybrid Mode
