Hello,
Are there any wild characters i can put to replace only the first two digits of the following string 02-7602-02.
i.e replace 02-7602-02 with 01-7602-02.
unfortunately, when I enter 02 in the FIND field and 01 in the REPLACE field, it also changes all other "02" in the string with 01.
Thanks
put 02-7602-02 to A2
B2
=IF(LEFT(A2,2)="02", REPLACE(A2,1, SEARCH("02",A2)+1, "01"))
there may be other pattern so best to upload a sample data
Christopher Yap
or can use
=SUBSTITUTE(A2,"02","01",1)
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
this seems to work better however it also changes the last two digits as well. I'm only interested in the first two digits regardless what numbers are afterOriginally Posted by shukla.ankur281190
Incorrect
01-7830-02 to 01-7830-01
Correct 02-7802-02 to 01-7802-02
No it is working perfectly fine to me
Check the file
Its not working for me not sure if im doing something wrong
Try
C2=IF(LEFT(TRIM(B2),2)="02",TRIM(SUBSTITUTE(B2,"02","01",1)),TRIM(B2))
you my friend.... saved me a ton of work i appreciate you taking the time to solve this. excellent job
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks