Thread: Selecting Characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Selecting Characters
Hi,

Am Sat, 28 Jun 2014 07:58:49 -0700 (PDT) schrieb :

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote