Possible to select a string in a locked cell?

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?
 
G

GS

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,

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top