Skip to content

Incorrect answer/question for 1_81-41_input #21

@jonhilgart22

Description

@jonhilgart22
"I need a VBA macro for my Excel sheet that will remove all instances of a single standalone dot (.) and the specific text '[Not Done (.)]' throughout my entire sheet. The macro must not remove dots that are part of valid values such as '32.5 mg/ml'. Additionally, I require the macro to replace these instances with  zeros. It's important that the macro functions correctly for the full sheet, even though I've only provided an example with my current sheet.",

These instructions imply that the agent should remove '[Not Done (.)]' with a zero.

Remove the first condition to make it clear. I need a VBA macro for my Excel sheet that will remove all instances of the specific text '[Not Done (.)]' throughout my entire sheet...Additionally, I require the macro to replace these instances with zeros.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions