Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 28th 14, 03:58 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 13
Default Selecting Characters

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.

  #2   Report Post  
Old June 28th 14, 04:34 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,685
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
  #3   Report Post  
Old June 29th 14, 01:56 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 13
Default Selecting Characters

On Saturday, June 28, 2014 10:58:49 AM UTC-4, wrote:
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Leading Characters If String Is Only 7 Characters Paperback Writer Excel Discussion (Misc queries) 2 April 21st 09 09:07 PM
Selecting only some characters, using "characters property" phil Excel Programming 0 January 24th 08 01:08 PM
Excel 2002: Single step of selecting characters Mr. Low Excel Discussion (Misc queries) 5 May 4th 07 05:12 PM
Selecting only certain characters from a cell value? drucey[_27_] Excel Programming 5 April 20th 06 01:23 PM
In Excel find characters when multiple characters exist w/i a cel teacher-deburg Excel Worksheet Functions 1 December 5th 05 10:22 PM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017