On Thu, 23 Mar 2006 03:35:37 -0600, coa01gsb
wrote:


Hi All,

I need to remove the first 9 chracters in every cell of column A of my
spreadsheet. What's the best way to do that?

My spreadsheet is currently huge, lots of data, graphs, functions and
defined names, all of which make it quite slow to load and manipulate.
I would like to avoid if possible making this too much worse. Not sure
if that will change the suggested best solution to my question above.

All help is much appreciated

Backup your workbook first!

In a helper column, enter the formula:

=REPLACE(A1,1,9,"")

Copy/Drag down as far as required.

Then,
Select the cells in the helper column
Edit/Copy
Select A1
Edit/Paste Special Values

Then Delete Helper Column.


--ron