TEXT2HEX

Owned by Juliane Wetzel
Feb 07, 2020
1 min read

Syntax

TEXT2HEX(<string>;<number>;<string>)

Description

TEXT2HEX returns each character's unicode value represented in hexadecimal. The second argument (optional) indicates after how many characters a delimiter should appear in the hexadecimal representation - the default is zero. The third argument indicates which character(s) should be used as a delimiter. The default delimiter is a hyphen (-).

Examples

Column1

argument1

argument2

TEXT2HEX returns

Hello



48656c6c6f

Hello

2


48-65-6c-6c-6f

Hello

3


486-56c-6c6-f

Hello

2

/

48/65/6c/6c/6f