Concatenation Different data types

[Hattrick16]

I am trying to create a new variable by concatenating two existing variables. The wrinkle is that they appear to be different data types.

Batch# = alphanumeric character.
Sequence = Nuneric I believe

I know the proper syntax
=Concatenation(<Batch Number> ,<sequence>)

I tries to nest a format number in the statement before the <sequence> but I still get an incorrect data type error

Am I going about this correctly and if not what is the correct syntax??

 

[BrianTyler]

Hattrick,

Try =Concatenation(<Batch Number> ,FormatNumber(<sequence>,"000000")

You can only concatenate alphanumeric strings

Brian

 

[skrandel]

Just use a + to concatenate different types.

<Batch Number> + FormatNumber(<sequence>,"000000")


Steve Krandel
Symantec