Unclear what you are trying to accomplish with all this. If the string in A1 is always the same,
=mid(a1,1,1) will pick off the first place character.
knowing that, you can concat as many instances of this as you like, thus:
=mid(a1,1,1)&mid(a1,1,1) and so forth
What are you trying to do?