Follow us on
Wednesday September 19, 2018
Total Stupid Comments : 8391

Stupid Client Quote #7413

Rate this Quote:

DexX | posted 11-26-2009 | Number of Votes: 38  |  Current Rating: 1.65   

#7420 - Sorry, I hate metacomments and normally never do them, but there's a quick fix for that spreadsheet in which some names are entered into cells as ="Name".

Basically, you copy the data and use "Paste special" to paste it (into a new column, or I suppose you could save time and post it over the top of itself) and only paste values.

This way, plain text will stay plain text, and those pointless formulae will be pasted as their resultant value only (also plain text).

Hope this helps!

Sorry everyone, helpdesk instincts kicked in. Had to share my solution. :)

BOOKMARK    #           REPORT