How to eliminate all cell references in a a text cell

S

Sid9

I have a sheet that has text cells that are derived from functions that combine text from other cells.

I want to have that text in cells that completely omit any references to other cells.

(I hope that's clear)

Thanks in advance!
 
E

Earl Kiosterud

Sid,

If you're wanting to convert the formula (which needs the references to the
cells) to permanent text (which will be made permanent with the current
text), copy the cells, then right over the same cells, do Edit (or
right-click) - Paste special - Values.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

I have a sheet that has text cells that are derived from functions that
combine text from other cells.

I want to have that text in cells that completely omit any references to
other cells.

(I hope that's clear)

Thanks in advance!
 
Top