Is there a toolbar ribbon method to put a linefeed within a cell? I have a user who wants multiple lines within the same cell. Unfortunately our users access Excel through Citrix, so the standard ALT-ENTER command is unavailable. ... it actually logs them out. Using Wrap text won't work...
Hi all,
I have a macro that combine data from a column into a cell. The macro ask to enter a separator in an inputBox and then combine all the data from a column range in a cell separated by the separator of interest.
Now I want to combine my data in selection with "alt-enter". I am not sure...
Hey,
As my last post regarding is not addressed I am posting this again.
I want to clean (removing non-printable character) and trim (removing extra spaces at the beginning and end) my data in selection within a column. As the clean function also remove alt-enter, I want alt-enter to be...
Hi,
I am trying to clean or trim my data in a column. My objective is to remove all non-printable characters and also the leading and tailing extra spaces or the ALT-enters. The code I have written also removes ALT-enters in the middle of the data :(. Please find my code below:
Sub CleanTrim()...
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.