Hi, I'm a beginner for Excel VBA.
What I want to do is to take out the first 15 characters in column C,
and copy the rest to clumn A. I have the following code, but VBA don't
recognize substitute funciton. Help....

Cells(n, 1).Value = Substitute(Cells(n, 3).Value, Left(Cells(n,
3).Value, 15), "", 1)