-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
hard return
-
D
VBA search for characters+hard return
Hello all! I have a series of cells I need to work on and separate the contents based on criteria. The common characteristic marking the point where I need to separate text is two commas followed by a hard return. How can I format the search criteria so it looks for ",," plus the hard return...- Dabenic
- Thread
- hard return vba vbcr vbcrlf vblf
- Replies: 15
- Forum: Excel Questions
-
M
Removing Leading Space after hard return in cell
I have a spreadsheet with items separated by a semi-colon and use Control + Shift + J to replace the semi-colon with a hard return. The ultimate goal is for all items to be stacked within the cell. However, whether I use Control + Shift + J or macros for replacing a character with a hard...- Micheleami
- Thread
- carriage return hard return items leading space return
- Replies: 6
- Forum: Excel Questions
-
Add Hard Return (Char(10)) and new Text to existing text in Cell
Hello, I've been given a spreadsheet with a series of cells which the person wants printed as labels. They would like add a hard return to the exisiting text, and also some addtional text to each cell ("Fiscal Year 2009/2010"). Here is a sample: Current Value Northwind Products Desired...- Smokeyham
- Thread
- char(10) add text hard return
- Replies: 8
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
