How do I change cells marked as #Name? to display as a string?

Hi,

I have a spreadsheet with a range of data I need to parse. Certain cells, as shown in the attached spreadsheet contain the value '#Name?'. The string(s) contained in the cells start with '=' sign. Is there VB code I can use to append/change these cells so the string contents display instead of the '#Name' for any row this is encountered in the spreadsheet?

Thanks,

mvem

Solution: How do I change cells marked as #Name? to display as a string?

To do this with code, see here.

                       
             Sub Macro1()
    Cells.Replace What:="=-- ", Replacement:="'=-- ", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
End Sub

Open in New Window

Select All