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)
.
|