0

This is my data:

43558#DEYINGCHEN20190403#097855111593#Logitech MX Master Wireless Mouse (910-004337)

Then I used split(#). Result:

enter image description here

The result I want is:09785111593

This cell I have formatted into Plain Text, but it failed anyway...

0

=ARRAYFORMULA(SUBSTITUTE(SPLIT(SUBSTITUTE(A1, "#", "♦#"), "#"), "♦", ""))

0

  • 1
    thank you so much!!!~~you're great! – YYY Trade Apr 4 at 14:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.