T trvlnmny Jun 28, 2014 #1 I want to create a new cell, D1, using A1 and the first character from B1 and the second character from C1. Thanks for any and all help.
I want to create a new cell, D1, using A1 and the first character from B1 and the second character from C1. Thanks for any and all help.
C Claus Busch Jun 28, 2014 #2 Hi, Am Sat, 28 Jun 2014 07:58:49 -0700 (PDT) schrieb (e-mail address removed): I want to create a new cell, D1, using A1 and the first character from B1 and the second character from C1. Click to expand... try: =A1&LEFT(B1,1)&MID(C1,2,1) Regards Claus B.
Hi, Am Sat, 28 Jun 2014 07:58:49 -0700 (PDT) schrieb (e-mail address removed): I want to create a new cell, D1, using A1 and the first character from B1 and the second character from C1. Click to expand... try: =A1&LEFT(B1,1)&MID(C1,2,1) Regards Claus B.
T trvlnmny Jun 29, 2014 #3 I want to create a new cell, D1, using A1 and the first character from B1 and the second character from C1. Thanks for any and all help. Click to expand... Thank you for your reply.
I want to create a new cell, D1, using A1 and the first character from B1 and the second character from C1. Thanks for any and all help. Click to expand... Thank you for your reply.
