| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Search Text and Add a Blank Line
Hi All,
New to the forum and have been searching (here and Google) for an answer with no luck. I am trying to automate the process of searching for specific text in a cell and adding a blank line before that text. Following is an example... Cells contain... Text:This is the first bit of text which is different for all cells. NewText: This is the text that I am manually placing on a new line beginning with 'New Text'. I am trying to get the cells to look like... Text:This is the first bit of text which is different for all cells. NewText: This is the text that I am manually placing on a new line. ** ** ** ** ** I have attempted creating a Macro and adjusting the code but have failed. Any ideas/help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatentate text and insert blank line | Excel Worksheet Functions | |||
| Search for specific text within last non blank cell in a range | Excel Worksheet Functions | |||
| Wrapping text leaves blank line when printing | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| Blank Line in Header Text | Excel Programming | |||
Threaded Mode
