Exporting xlsx sheet names that don't have apostrophes surrounding them

[ppatane]

I am trying have a workflow, that upon output, renames the sheet to Sheet1, but it always comes up in the Excel file as 'Sheet1'. The attached workflow goes through removing the spaces and hyphens from the name, but no matter what I do, I end up with the apostrophes

[OTrieger]

@ppatane 
This formula is failing:
Replace([FileName], "'", "")

[OTrieger]

IT seems that the apostrophe that you are trying to replace is a different apostrophe. When this is happening to me I just double click on the path in the Result window and copy and paste the apostrophe from the text itself

[ChrisTX · Accepted solution]

The apostrophe in your data seems to be a "smart quote", which is different from the normal apostrophe you can type on your keyboard.

Not sure if the correct smart quote character will paste correctly into this Reply window, but try this in a Formula:

ReplaceChar([FileName], "`", "")

In the Results pane, you can double-click one of the cells that contains a character that looks like an apostrophe.  This will open the Cell Viewer.  Then copy the character and paste it into a Formula tool, and use a function like ReplaceChar.

 

Chris

[OTrieger]

You have straight apostrophe slanted apostrophe, apostrophe  with tail to the right, to the left, they are all different characters from the computer perspective, so you need to ensure that you delete the one that you have in the text.

[ppatane]

Grazie! Molto bene! Was not familiar with the ReplaceChar formula