i am wanting to create a template so that when you copy and paste your a,b.c all contained in one cell it appears somewhere else as a in a cell beside be , is there a formula i can use to do this ?
thanks
lewis
i am wanting to create a template so that when you copy and paste your a,b.c all contained in one cell it appears somewhere else as a in a cell beside be , is there a formula i can use to do this ?
thanks
lewis
Err, like this?
a=LEFT(A1,1)
b=MID(A1,3)
c=RIGHT(A1,1)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks