G
Guest
I know how to combine the contents of 2 cells (example: cell A1 "1234" and
cell B1 "567") by using =(A1&""&B1) resulting in "1234567". How can I
combine the cells but dropping the last digit in A1 to have a result as
"123567"? I found help in doing this before but can not locate it. I
remember using the above function but with a slight adjustment.
Thank you!
cell B1 "567") by using =(A1&""&B1) resulting in "1234567". How can I
combine the cells but dropping the last digit in A1 to have a result as
"123567"? I found help in doing this before but can not locate it. I
remember using the above function but with a slight adjustment.
Thank you!