Removing Carriage Returns From Cell - Ctrl+J or Alt+010 Not Working

olimits7

Board Regular
Joined
Oct 29, 2004
Messages
202
Office Version
  1. 365
Platform
  1. Windows
Hi,

I'm trying to use Find/Replace to remove carriage returns from my Excel sheet but when I try either Ctrl+J or Alt+010 it doesn't seem to remove the carriage returns from the cell. I get the message "Couldn't find anything to replace" from Excel.

Does anyone have an idea why this isn't working?

I'm using latest Office Excel 365 version on Windows 10.

Thank you!
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Giordano Bruno

Well-known Member
Joined
Jan 7, 2007
Messages
1,237
Hi o7. I'm using Office 365 and windows 10 and Ctrl-J works for me. Perhaps turning the computer of, turning three times anticlockwise with your eyes shut chanting "Sod Microsoft" and turning the computer back on will fix the problem.
 

Marc L

Well-known Member
Joined
Apr 5, 2021
Messages
927
Office Version
  1. 2010
Platform
  1. Windows
Hi,​
as a reminder :​
  • Line Feed : #10
  • Carriage Return : #13 …
 

Watch MrExcel Video

Forum statistics

Threads
1,132,914
Messages
5,655,937
Members
418,253
Latest member
TheJackal26

We've detected that you are using an adblocker.

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.
Go back
Top