If cell length is over 40, take all characters after the 40 and put them in another cell

[MICowboy13]

Hi all,

Can I use VBA to accomplish this? If cell length is over 40, take all characters after the 40 and put them in another cell.

This is what I'm looking for;
For all rows in Sheet1 if column E has a length over 40 characters then move all additional characters, after the 40, to the same row, but in column F.


Thanks in advance

[StephenR]

E.g.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[MICowboy13]

Thanks guys! Both are good solutions. i went with John's solution as it was necessary to count the rows. I appreciate all of the help!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.