How do I get Excel to go to the first row where the first cell st.

K

KennLee

How do I get Excel to go to the first row where the first cell starts with a
specific character? I want to place a link for A-E, F-K, l-P, etc., so I can
click to gget to the start of a preferred range.
 
B

bigwheel

CODE returns the numeric code for the first character in a text string. So
if cell A1 contained "Frank", CODE(A1) would return 70. Upper and lower
case letters return different values, "frank" would return 102, whether
this is any help. If you are tryinh to link to a known range you could
always set a hyperlink, use the bookmark button to set the link to the
range.
 
D

Dave Peterson

Maybe you could just use the =hyperlink() worksheet function:

=HYPERLINK(A10,"a-e")

Where A10 represented the first cell in the A-E group.
 
Top