ExcelBanter - Selecting Characters

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Selecting Characters (https://www.excelbanter.com/new-users-excel/450180-selecting-characters.html)

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.

Claus Busch

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

[email protected]

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.

All times are GMT +1. The time now is 02:44 PM.