Need Formula to tell me the contents of other formulas
Hey guys...
I need a little help... Is there any formula that can look in a cell and tell me if there is a "+" in it?
Ie: Cell A1 =5+7
Cell A1 shows 12
Is there a way to pull the 5 and 7 out separately, or at least tell me if the cell has a + in it as opposed to being just a single number?
Thanks in advanced guys!
Cheers
You can switch back and forth to "Show Formulas" with CNTRL SHFT ~
Does that help?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Unfortunately not... I need to perform an operation, or at least call attention to cells containing more the sum of more than one number...
Good thinking though
There is no Function. There's not even a direct function to tell if it's a formula until Excel 2013. You could create a function using VBA.
Thanks again Chemist
Okay, we can use a simple UDF to get the formula (in the VBA editor, insert a module and put this into it)
Then you can use this formula to count the number of plus signs
Please Login or Register to view this content.
=LEN(GETFORMULA(A1))-LEN(SUBSTITUTE(GETFORMULA(A1),"+",""))
Is that what you are looking for?
This serves my purposes perfectly
Thanks ChemistB!!!!!
If you are always going to be looking for Pluses, you can use this UDFPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks