Image below has a 500 cells I want to delete the 12 digit number but the numbers that align to the 12 digit was in one cell so it is hard to do manually how to delete it need help thanks in advance
ss.jpg
Image below has a 500 cells I want to delete the 12 digit number but the numbers that align to the 12 digit was in one cell so it is hard to do manually how to delete it need help thanks in advance
ss.jpg
will the length of the text always be same?
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
Use Find & Replace
Select the data
Press Ctrl+F
In Find what enter the search value
Leave the Replace With blank
Press Replace All
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Use this formula if the text length is always same. adjust the 17 as per your requirement in the formula if required
PHP Code:
=RIGHT(A1,17)
Yes always be the same
thank you so much!
Please mark this thread as solved, if u got your solution....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks