How to transfer only numbers from this 4fassf[2fas4 and result : 424
How to transfer only numbers from this 4fassf[2fas4 and result : 424
Why do you keep posting in the Office 365 section when you don't have Office 365???
I am moving your thread (again).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry, i need post here /excel-general/ yes?
No - I have moved the thread to the appropriate section.
In Excel 2016 you will probably need to array enter this formula.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
With the understanding your source text is in A1 this formula (which I got from XOR LX who in turn got it from someone named Lori.)Formula:Please Login or Register to view this content.
Dave
Thank You!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks