Macro to add a new row if text length is over 30

  • Thread starter Thread starter Melanie
  • Start date Start date
M

Melanie

I need a macro to add a new row (and copy existing data in columns A-R) if
the length of the items in column S is over 30. If the text is over 30, I
need to move the characters over 30 in the new row in column S. I have the
data length of column S in column Z.

Can someone help me with this? Thx!
 
To clarify, I mean if the length of the characters in the column S cell is
over 30, I need to move characters 31+ to the new line.
 
I forgot to mention that the data in column S are names delimeted by "^" so
it's not just the first 30 characters I need to worry about. I need the names
to not be split up and the "^" removed at the end of the line if the data is
move to the new line.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Specific Rows in Range and Create New Tab 18
Sort on 3 columns when number of rows vary daily 1
Macro to delete rows 4
Text To Columns then insert rows 9
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Tax Form with Merge and Center 7
Macro to delete last entry of a column 5
excel macro 5

Back
Top