how to make 2 data each from seperate column into one

[zackdy]

Example:before

ID.........SEC.........
oa........ .........
ob........asd .........

so at this point if i want ob and asd combine and add "_" in between to get this result "ob_asd" is this possible?

[JOHN H. DAVIS]

If ID is Column A and SEC is Column B, then maybe this can help.

=A2&"-"&B2

[zackdy]

can i use this also "=IF(ISBLANK(B2),A2,A2&"_"&B2)"?
My Oa doesnt have anthing in column b so i try to do so with the formula above and it display only what is in a2 which is what i wanted.

[zackdy]

Here another one sry if it bothers u so much but what if let say

ID Password
a asd
a qwe
a zxc
how do i like select one id and display out the password then if let say the first id,the password has been taken then it will take the second password since its the same ID using If statement hopefully there's a solution to this.

[JOHN H. DAVIS]

can i use this also "=IF(ISBLANK(B2),A2,A2&"_"&B2)"?
My Oa doesnt have anthing in column b so i try to do so with the formula above and it display only what is in a2 which is what i wanted.

Should work. Did you try it?

[zackdy]

yea it work that but i need just one more help on the one that say password thing hope u can help me too on that and that would be my last question the password thing is above ur reply on my post