You are out of luck on this one. There is no automated way via macro or
otherwise to select only a protion of a cell's contents. Your only optoin is
to manually select the portion you want...
--
HTH...

Jim Thomlinson


"Eric" wrote:

Refer to the post in Worksheet functions

Does anyone have any suggestions on how to select a listed item?

There is a list of items in cell A1, such as
A and B
I would like to create a macro shortcut to change the value of cell A1, such
as
if I click Ctrl+Shift+A, then A will be selected in cell A1,
if I click Ctrl+Shift+B, then B will be selected in cell A1,

Does anyone have any suggestions on how to do it?
Thanks you in advance for any suggestions
Eric