Combining 2 fields from excel

[ljames88]

I need to combine a number field and a string field together to create a new field.  I am having issues since they are different types, any suggestions..

For example Field 1 = 1920394

Field 2 = UGA

want to create 1920394UGA

[Anonymous]

In Excel you need to convert the number to text, then combine them.

A1=1920394, B1=UGA

The Text function needs a format and "#" says it displays the numerals.

Formula:

=TEXT(A1,"#")&B1

1920394UGA

This also works with dates. Copy the date formatting from the Custom formats when you select Format Cell. You can vary as needed.

[Anonymous · Accepted solution]

Field1 & Field as Newfield

In the load script.

[Anonymous]

LOAD A,
B,
A & B AS NEWFIELD
FROM
[\\test data.xlsx]
(ooxml, no labels, table is Sheet1);