Selecting Characters


T

trvlnmny

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.
 
Ad

Advertisements

C

Claus Busch

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.

try:
=A1&LEFT(B1,1)&MID(C1,2,1)


Regards
Claus B.
 
Ad

Advertisements

T

trvlnmny

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.

Thank you for your reply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looping through permutations 7
Excel Add ^ to a row of cells containing letters 3
Excel 2
Retrieve last non zero value in a range of cells 2
Index left match or lookup??? 2
ROUNDDOWN 3
formula help 5
Conditional Concatenate? 2

Top