Easy way to change names?

  • Thread starter Thread starter Carl Rapson
  • Start date Start date
C

Carl Rapson

I have a spreadsheet that was converted from Lotus 123 to Excel format, and
I'm having a little problem with the names. The original spreadsheet
contains a lot of names that begin with digits (like
01DATA,02DATA,03DATA,...), and these names were converted directly to Excel
without modification (I converted from 123 because Excel wouldn't even open
the original file without crashing). The problem is, Excel doesn't allow
names to begin with digits.

So, I'm having to go through and add an underscore to each invalid name, and
then locate each reference in the workbook and change it there also. Is
there a quicker way to do this? I haven't been able to find any way to do it
except manually, one name at a time, which is tedious and might miss some
references.

Any information would be greatly appreciated.

Carl Rapson
 
Carl,

You could use Find & Replace on the Edit menu to update your references.
That way, you're unlikely to miss any of them.

HTH
Henry
 
-----Original Message-----
I have a spreadsheet that was converted from Lotus 123 to Excel format, and
I'm having a little problem with the names. The original spreadsheet
contains a lot of names that begin with digits (like
01DATA,02DATA,03DATA,...), and these names were converted directly to Excel
without modification (I converted from 123 because Excel wouldn't even open
the original file without crashing). The problem is, Excel doesn't allow
names to begin with digits.

So, I'm having to go through and add an underscore to each invalid name, and
then locate each reference in the workbook and change it there also. Is
there a quicker way to do this? I haven't been able to find any way to do it
except manually, one name at a time, which is tedious and might miss some
references.

Any information would be greatly appreciated.

Carl Rapson


.
Try highlighting the cells with names in them and then go
Click to expand...
to Format - Number and choose - Text. They should appear
with the digits.
 
Back
Top