• Miscellaneous Functions
  • Miscellaneous Functions
  • BROWSTAT function
  • CELLCALC function
  • CELLCOL function
  • CELLLABEL function
  • CELLNO function
  • CELLROW function
  • CELLSTR function
  • CELLTABLE function
  • CUSTPROP function
  • CUSTPROPAT Function
  • CUSTPROPR function
  • CVDATA function
  • CVDATAC function
  • CVDATAL function
  • CVDATALNG function
  • CVDATAQRY function
  • CVDOCPOS function
  • CVFORM function
  • CVGROUP function
  • CVIDEA function
  • CVINFO function
  • CVMENUST function
  • DOCID function
  • DOCMODE function
  • EVAL function
  • GETHIDE function
  • INITIALS function
  • ISCONS function
  • ISINGROUP function
  • ISINGRP function
  • KLIEXIST function
  • KLIPROP function
  • KLLPROP function
  • LEVEL function
  • LOOKUP function
  • MKPATH function
  • RDYREVIEW function
  • REPENT function
  • SCRNX function
  • SCRNY function
  • WHOAMI function

MKPATH Function

The MKPATH function converts a string parameter path name to an expended path string by replacing each \ with a \\.

Syntax

MKPATH(expression)

Example 1

mkpath("a\b\c")

Returns a\\b\\c

Example 2.

mkpath(c5)

Returns a\\b\\c if cell c5 contains "a\b\c"

Example 3.

mkpath("\\a\\b\\c")

Returns \\a\\b\\c

Example 4

mkpath("\\a\b\c")

Returns \\\\a\\b\\c (network path)

Example 5

mkpath("c:\a\b")

Returns c:\\a\b

Related Topics

• Miscellaneous Functions