Combine two text columns

[JPiercefield]

Hello,

I have two columns. 

1) Employee First Name

2) Employee Last Name

I need to have a column that takes the first initial from column one and combines it with the full name from column two.

Example would be

1) Bob

2) Sagget

Outcome = bsagget

What is the best method to use here?

Thanks!

[tamerj1 · Accepted solution]

Hi @JPiercefield 

you can use

New Column =
LEFT ( TableName[Column1], 1 ) & TableName[Column2] 

[JPiercefield]

So simple.. thank you!