Hello,
Can you help to remove characters and retain just the numbers "0012383810".
Customer 0012383810 was created for sales area DE01 14 02
Thanks!!!
Hello,
Can you help to remove characters and retain just the numbers "0012383810".
Customer 0012383810 was created for sales area DE01 14 02
Thanks!!!
Try this:
Formula:Please Login or Register to view this content.
However, this will return you number without first 0's.
Hi,
could you share some more example in order to undestand if there is a general rule we can exploit using MID or LEFT?
a possible approach:
=LEFT(Substitute(A1,"Customer ",""),10)
Cheers
Edit: sorry Zbor, I did not mean to overlap!
Last edited by canapone; 10-13-2014 at 09:39 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
tRY
Hoping SAP text Messages start from "was" after the relevenat ref numbers
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Hi all,
Thanks so much for the help!
I have tried all the formulas you gave and it worked fine
Thanks agian!
Oops, misread the requirements.
Last edited by newdoverman; 10-13-2014 at 10:15 AM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Try this one
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",25)),25,25))
Row\Col A B 1Customer 0012383810 was created for sales area DE01 14 02 0012383810
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
This also seems to work:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks