Replies to post #117 on Learning Microsoft Excel

[MSC290]

Solutions for the problem:

#1 (the easy way) Go to the Learning Microsoft Excel board and post a message to lobogotti and say HELP!

#2 (the hard way) Tax your brain for quite some time doing numerous trials and errors to come up with the following formula to place in cell B1:

=CONCATENATE(MID(A1,1,1),"*",MID(A1,2,1),"*",MID(A1,3,1),"*",MID(A1,4,1),"*",MID(A1,5,1),"*",MID(A1,6,1),"*",MID(A1,7,1))