Need help finding the list of alphabets between two letters

[tamtammg]

Hello everyone,

I need some help creating a VBA code to list the alphabets (in order) between two letters. Something like this:

GetLetters(A1,B1) -> bcdefg

A1 = b
B1 = g

Is there a way to show the string 'bcdefg' in one cell? Please see the attached image.

Thank you guys in advance!

 

[jimrward]

assuming they are all lowercase and A1 and B1 are in alphabetic order, you could use say F1 to hold the characters from a-z and use the following

Book1
	A	B	C	D	E	F
1	b	g	bcdefg			abcdefghijklmnopqrstuvwxyz
Sheet1

Cell Formulas
Range	Formula
C1	C1	=MID(F1,FIND(A1,F1),FIND(B1,F1)-FIND(A1,F1)+1)

 

[Fluff]

Hi & welcome to MrExcel.
as long as both characters are the same case, how about

Function tamtammg(FirstLet As String, LastLet As String) As String
   Dim i As Long
   
   For i = Asc(FirstLet) To Asc(LastLet)
      tamtammg = tamtammg + Chr(i)
   Next i
End Function

 

[tamtammg]

Thank you both for the response!!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Peter_SSs]

In case you are interested, another formula approach (IF you have Excel 365** with the SEQUENCE function) is shown below.

** I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

20 10 17.xlsm
	A	B	C
1	b	g	bcdefg
Letter sequence

Cell Formulas
Range	Formula
C1	C1	=CONCAT(CHAR(SEQUENCE(CODE(B1)-CODE(A1)+1,,CODE(A1))))