Excel VBA: Inserting Rows Based on Number contained in Cells -

i think easiest way desired answer describe entire scenario. company tracks projects using primavera. scheduler exports data excel , manipulates data own uses. manipulation automated using macros doesn't have repeat same process every time. of simple, have stumbled on 1 part.

the first column in workbook project number + name. there 2 types of projects: small projects have 3 digit number optional subtask number , large projects have 4 digit number optional subtask number. cell comprised of both numbers , text. general format follows:

small projects

123 small project #1

or

123-4 small project #2

large projects

1234 large project #1

or

1234-5 large project #2

he inserts 3 rows separate 2 project types (small projects , large projects lumped together). there way, using vba, automate process?

i thinking go along lines of "if first 4 characters in cell numbers, largeproject = largeproject + 1, else smallproject = smallproject + 1". don't know expression (if 1 exists) can utilized accomplish this.

thanks!

if txt "### *" or txt "###-*"    'small project elseif txt "#### *" or txt "####-*"    'large project end if