Dear All,
I want to split long text (which contain digit and text) in separate cells example - If Cell A1 contains 3D 6A 4Z O9 So answer Should be - 3D should be in A2, 6A should be in B2, 4Z sholud be in C2, and O9 should be in D2 and so on......
Is there any formula in excel or vba code.
Attache sample file for reference....
thanks in advance
Dev
Hi,
Will the strings in question always be of an identical format to the one you give, i.e. four sets of two characters separated by a single space?
Regards
Yes it will be always in same format
Dev
In A2 and copy across:
=TRIM(MID($A$1,3*(COLUMNS($A:A)-1)+1,2))
Regards
Dear XOR LX,
Thanks for ur help it works great for me...
Dev
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks