Need to join two values together into one field

[p3x935]

Heres what i have... i have a spreadsheet with two columns. One colum is DEVICE LOOP, the other is DEVICE ID.
I need to take the device loop value and join/append it with the value in the next column.. and put a dash between them.

Example
DEVICE LOOP | DEVICE ID
1 | 205


I need it to make it....
1-205
and put that into a new field in a new column...

I am new at this.. and my terminology may not be right. English is not my primary language.

[Sean Thomas]

if A2 contains 1
B2 contains 205
in C2 enter =A2 & "-" & B2


Sean

[martindwilson]

=a2&"-"&b2 should do it

[haripopuri]

Assuming cell A2 & B2 are having your values, Type this in C2

Please Login or Register  to view this content.

You can also use function CONCATENATE