bbimis
asked on
word count of word document exported into excel
how would i go about doing the following. code example would be great..
lets say i have a document named test 10-14-15.rtf and i want to export statistics to an excel worksheet that is seperated by month.
so i have for instance 100 lines of i want it to do something like this
Date | lines
<gotten from title>| <gotten from word count statistics>
is this possible and how can i do it?
lets say i have a document named test 10-14-15.rtf and i want to export statistics to an excel worksheet that is seperated by month.
so i have for instance 100 lines of i want it to do something like this
Date | lines
<gotten from title>| <gotten from word count statistics>
is this possible and how can i do it?
do you have a sample of .rtf to upload here? we probably can't directly read a .rtf to Excel.
Assuming
a1=10-14-15.rtf
Then in B1 you can do this...
And if you want to convert that value as date then you can do this...
Format that as date and you will get the result what you are trying to achieve..
Saurabh...
a1=10-14-15.rtf
Then in B1 you can do this...
=SUBSTITUTE(A1,".rtf","")
And if you want to convert that value as date then you can do this...
=DATEVALUE(SUBSTITUTE(A1,".rtf",""))
Format that as date and you will get the result what you are trying to achieve..
Saurabh...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks that worked great