Possible to select a string in a locked cell?

  • Thread starter Thread starter Ward Webber
  • Start date Start date
W

Ward Webber

My worksheet has a column of names--first, last, middle--that I want to prevent changes to. So I locked the column successfully, choosing to allow cell selection, although I didn't see an option to allow string selection within a cell.

But I need to be able to select just a string from a locked cell; just the first name, for example, so I can copy it and paste it elsewhere. I can select the whole cell, but I'm not being allowed to select a string from the cell.

Is it possible to select a string in a locked cell?
 
My worksheet has a column of names--first, last, middle--that I want
to prevent changes to. So I locked the column successfully, choosing
to allow cell selection, although I didn't see an option to allow
string selection within a cell.

But I need to be able to select just a string from a locked cell;
just the first name, for example,
Click to expand...

first, last, middle in A1:

=LEFT(A1,FIND(",",A1)-1) in B1 returns "first"

Formula doesn't need to be in an unlocked cell, but should be put in
the cell you want to copy/paste to. Also, look up using the MID() and
RIGHT() functions in combination with FIND().

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top