Count spaces in NumberFormat with ExcelScript using OfficeScripts in Excel for Web

Question

I have to count the spaces within in NumberFormat of each cell in column A. Here is an example NumberFormat:

"                       "@

I translated my VBA code into OfficeScripts ExcelScript (for Excel for Web) but it seems that the replace function doesn't removes the spaces:

sheet.getRange("A1").getNumberFormat().length - sheet.getRange("A1").getNumberFormat().replace(" ", "").length

Is there another option to count the spaces or did I something wrong with the replace function (other letters will be replaced correctly)

Paintitblack3k · Accepted Answer · 2021-04-06 12:31:32Z

2

It's just the JavaScript syntax and the solution is:

sheet.getRange("A1").getNumberFormat().length - sheet.getRange("A1").getNumberFormat().replace(\s/g, "").length

answered Apr 6, 2021 at 12:31

Paintitblack3k

751 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1