Maybe something like

=MID(the_full_name,COLUMN(A1),1)

and copy across

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"BOBODD" wrote in message
...
I have a form that collects the user's bank account details in 2 textboxes
(one for the account name, the other for their account number). The
preprinted forms that we use have boxes for each character of the name &
digit of the account number.

I've set up cells to match the placement of these boxes, but I'm trying to
work out how to use VBA to split the client details across these cells. I
can do this using functions, but I want to avoid having functions
appearing
in what will be unlocked cells.