|
or else just use:
=left(A1,8)
=mid (A1,9,50)
It basically means:
take the first 8 characters on the left
take the 50 characters in the middle, starting from the 9th one in)
If you have fixed characters, thats sometimes easier than using text to columns, as you can resort if
ie - if you wanted to reverse it so the name was first and the course code last you could go:
=(mid(A1,9.50)) & (left(A1,8))
_
__________________
"Do not tell lies, and do not do what you hate,
for all things are plain in the sight of Heaven. For nothing
hidden will not become manifest, and nothing covered will remain
without being uncovered."
The Gospel of Thomas
|