Carriage Return or Line Break or ALT+Enter in Cell problem

zubair99

New Member
Joined
Aug 8, 2015
Messages
49
Why Carriage Return or Line Break or ALT+Enter adding automatically in every excel cell ?
is it a virus or corrupted excel software because I did not put anything its auto adding in every cell ?
I have reinstall office 2013 many times and windows 7 also but same problem every time.
please help thanks.
 
data not auto-added. I said that carriage return are adding auto in every cell whether its empty or not.
like this
HB-
BACKPACK-17--------"

I put dashes for represent extra space

it should be look like this with no space or carriage return in the end
HB-BACKPACK-17
 
Upvote 0

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
If you drag the formula further to the right, what do you get?
 
Upvote 0
In that case there is no carriage return between the - & the B (of backpack)
 
Upvote 0
If you keep extending the formula to the right until you get a #VALUE!
What do you get between 45 49 45 and the error?
 
Last edited:
Upvote 0
In that case there are no spaces, carriage returns, or any other type of hidden character in the cell.
 
Upvote 0
when I put any text from excel to windows command prompt its acting like running command for that I dont need hit enter it will automatically run.
and when I copied text from online excel to CMD than its act like normal text paste.
 
Upvote 0
I have no idea why that happens, but you do not have a carriage return in the cell.
Even if you did I doubt it would act as such when pasted into the command prompt.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,954
Members
448,535
Latest member
alrossman

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
Back
Top