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

[zubair99]

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.

 

[zubair99]

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

 

[zubair99]

I put =CODE(MID($A$1,COLUMN(A1),1))

its return in right cells 72 66 45

 

[Fluff]

If you drag the formula further to the right, what do you get?

 

[zubair99]

[TABLE="width: 512"]
<tbody>[TR]
[TD="width: 64, align: right"]72[/TD]
[TD="width: 64, align: right"]66[/TD]
[TD="width: 64, align: right"]45[/TD]
[TD="width: 64, align: right"]66[/TD]
[TD="width: 64, align: right"]65[/TD]
[TD="width: 64, align: right"]67[/TD]
[TD="width: 64, align: right"]75[/TD]
[TD="width: 64, align: right"]80[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

In that case there is no carriage return between the - & the B (of backpack)

 

[Fluff]

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?

 

[zubair99]

[TABLE="width: 1088"]
<tbody>[TR]
[TD="width: 64, align: right"]72[/TD]
[TD="width: 64, align: right"]66[/TD]
[TD="width: 64, align: right"]45[/TD]
[TD="width: 64, align: right"]66[/TD]
[TD="width: 64, align: right"]65[/TD]
[TD="width: 64, align: right"]67[/TD]
[TD="width: 64, align: right"]75[/TD]
[TD="width: 64, align: right"]80[/TD]
[TD="width: 64, align: right"]65[/TD]
[TD="width: 64, align: right"]67[/TD]
[TD="width: 64, align: right"]75[/TD]
[TD="width: 64, align: right"]45[/TD]
[TD="width: 64, align: right"]49[/TD]
[TD="width: 64, align: right"]55[/TD]
[TD="width: 64, align: center"]#VALUE![/TD]
[TD="width: 64, align: center"]#VALUE![/TD]
[TD="width: 64, align: center"]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

In that case there are no spaces, carriage returns, or any other type of hidden character in the cell.

 

[zubair99]

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.

 

[Fluff]

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.