How to add Equals sign to entire column

**barbachjordan** · 03-18-2010, 07:26 PM

Sorry for the extremely noob question.

But I basically have 300 rows of numbers being multiplied, but without the equals sign there (i.e. 3*5, but forgot to put the equals sign to make it calculate)

So how can i put an equals sign in front of all of these? Hopefully i don't have to manually put in an equals sign to make all 300 rows calculate.

**shg** · 03-18-2010, 07:31 PM

If the expression is in A1, then in B1 and copy down,

="=" & A1

The select col B, Edit > Copy, Edit > Paste Special, Values. Now col B looks like =3*5, but it's text.

With col B still selected, Edit > Replace = with =. Now they have formulas.

Then delete col A.