| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to add a new row if text length is over 30
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to add a new row if text length is over 30
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. "Melanie" wrote: 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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to add a new row if text length is over 30
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. "Melanie" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| limit text length in a text box in excel 2003 | New Users to Excel | |||
| Limiting physical length of text in a text box control | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Linear Mode
