hello all,
I have values in a column as, start from a1 :
a1-------sebidang tanah, luas 300 m2. SHM nomor 23
a2-------tanah seluas 786 m2. SHGB No.45
a3-------tanah seluas 200 m2. AJB Nomor 568/KN/1999
i want to output :
b1-----SHM nomor 23
b2-----SHGB No.45
b3-----AJB Nomor 568/KN/1999
for your help is greatly appreciated.
jhon mustofa
hi jhon mustofa. try:
=MID(A1,FIND(".",A1)+2,LEN(A1))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Try this, copied down...
=MID(A1,SEARCH(".",A1,1)+2,99)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Or this:
=REPLACE(A1,1,FIND(".",A1)+1,"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
it's very simple query..100% worked..
many thanks...
You're Welcome and thank you for your feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks