Pass a variable a text to substring count

[tinkerz1]

Hi ,

How do I pass a variable as text to substring count?

Thanks

T

=SubStringCount($([Curent Spreadsheet]),'\')

[oscar_ortiz]

Simply wrap the dollar sign expansion in single quotes.

'$(yourvariable)'

[tinkerz1]

Thanks, however when continute to expand the formula to

=index('$(Current Spreadsheet)',SubStringCount('$(Current Spreadsheet)','\')) 

It returns zero, why wont index pick up the number?

The next stage is to wrap the above formula inside left('$(Current Spreadsheet)',above formula)

Thanks

[marcus_sommer]

Your expression searched within a string (your variable) the number of backslashes within them, like:

index('string', 3)

is it what do you want to do?

- Marcus

[oscar_ortiz]

What is the actual value of your variable?  Also, I don't believe variables can have spaces.