#NAME? issue in excel

[vrachimis]

Hi all

I need to copy a list of 100k entries like the one below.
=-ad-vehicles.

Problem is when i paste, i get #NAME ? in the cell.

I know it's doing this because excel thinks this is a formula function but how do i work around this considering that i have to deal with 100K entries?

 

[Aladin Akyurek]

What is it if it's not a formula? Text?

 

[vrachimis]

What is it if it's not a formula? Text?

Yes. It's pure Text.

 

[Aladin Akyurek]

Yes. It's pure Text.

Then it should be:

="

-ad-vehicles​

"