I am developing a spreadsheet to be distributed to numerous individuals for
updating and returned to me to be compiled. I have a column for account
number which consists of a 6-segment number, each segment separated by
hyphens. I need recipients to edit the middle two segments and return to me.
I want to create another column that duplicates the account number string
except for the middle two segments, and either highlight the segments to be
edited or mask the two segments to ensure correct number of digits are
entered for the segments. How can I accomplish this?
--
Twinspar