ExcelBanter - extracting a single char from a string of chars

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - extracting a single char from a string of chars (https://www.excelbanter.com/excel-programming/337517-extracting-single-char-string-chars.html)

Alan

extracting a single char from a string of chars

I need to extract a single char from a string of chars. Exaple

String of ABCDE I want to be able to select D

Ron de Bruin

extracting a single char from a string of chars

Hi Alan

Try this with ABCD in A1
=MID(A1,4,1)

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Alan" wrote in message ...
I need to extract a single char from a string of chars. Exaple

String of ABCDE I want to be able to select D

Alan

extracting a single char from a string of chars

Ron,

Brill thanks very much

"Ron de Bruin" wrote:

Hi Alan

Try this with ABCD in A1
=MID(A1,4,1)

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Alan" wrote in message ...
I need to extract a single char from a string of chars. Exaple

String of ABCDE I want to be able to select D

All times are GMT +1. The time now is 10:21 AM.