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...
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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.