How to eliminate all cell references in a a text cell

  • Thread starter Thread starter Sid9
  • Start date Start date
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!
 
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!
 
Back
Top