0

CONCATENATE (really a Excel-question)

Hi!

This is really a Excel-question, but I'll try here anyways =)

AB48 =CONCATENATE(AF48;" ";AG48;" ";AH48;" ";AI48)
AF48: =NL(-1;"Comment Line";"Date";"Table Name";"JOB";"No.";4851) (This gives a date)
AG48: =NL(-1;"Comment Line";"Code";"Table Name";"JOB";"No.";4851) (This gives "REV06")
AH48: =NL(-1;"Comment Line";"Comment";"Table Name";"JOB";"No.";4851)
AI48: =NL(-1;"Comment Line";"Comment2";"Table Name";"JOB";"No.";4851)

AB48 shows: 40846 REV06 Dette er en test 123

The problem is that I want to show the date, not 40846.

Any ideas on how to to this?

8 comments

Please sign in to leave a comment.