I'm supposed to program it in a way that it lists out all the 3-word phrases found in a document.
Example in a passage:
(Mary had a little lamb,and the lamb was white as snow)
So it will give me these results in EXCEL in a list:
Mary had a
had a little
a little lamb
lamb,and
.
.
Now the problem is, "lamb,and" must be removed cause it contains punctuations.
How do I delete those cells that has punctuation marks?
I cannot delete the entire row.
I must delete only that particular cell.
--------------------------------------------
Anybody knows the code for this?
If yes, please help.
Really urgent cause the project is due soon.
thanks!!
2007-11-17
05:40:57
·
1 answers
·
asked by
SPB
1