I have a cell containing both text and numerics i want to spilt it in different cell containing text and numerics.
NIKUNJ12345 spilt it in NIKUNJ and 12345 in different cells.
NIK123 spilt it in NIK and 123 in different cells.
N123456789 spilt it in N and 123456789 in different cells.
The main problem is format is not fix.
I have attached a sheet too.
In C3: =LOOKUP(99^99,--("0"&MID(A3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0123456789")),ROW($1:$10000))))
In B3: =SUBSTITUTE(A3,F3,"")
Thanks a lot dear.
CA Nikunj Dasani
India
the search function would have yielded the answer
but here you are
ABC.xlsx
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
remember to mark it solved and star tap the helpers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks