In excel. How do I split a string of 20 characters(serial number) which has a mixture of number and letters but without commas or spaces? I want to split it after the 14th character which is normally a letter and start the next cell with the 15 character which is a number. Thanks in advance.
=right(a1,6)
or
=mid(a1,15,6)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks