Hi,
I have a cell from a database which doesn’t split out the text and numbers into separate columns so I would like to do this manually.
I have the following codes to split certain elements out:
Text
Number
Please Login or Register to view this content.
(CSE Formula)Please Login or Register to view this content.
The Problem I have is that it doesn’t deal with the fact it’s a negative number, is there a workaround?
Hi,
With sample data this seems to work,
Extract number first with below formula in E16
=LOOKUP(9.9999999E+307,--RIGHT(B15,ROW(INDIRECT("1:"&LEN(B15)))))
Than text with below formula
=TRIM(SUBSTITUTE(B15,E16,""))
Regards,
Using your posted workbook,
this regular formula returns the number from the end of the text
Is that something you can work with?Please Login or Register to view this content.
Another Try but not clever solution
Regards
Or this
=LOOKUP(25^25,--RIGHT(B15,ROW(A$1:A$1000)-1))
Last edited by AlKey; 11-18-2014 at 02:38 PM.
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
Thanks all - all codes supplied worked!
You're welcome and thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks