There is Cell A1:
=1+2+3+4
how to remove "=" so that Cell B1 is:
1+2+3+4
(NB. it is not same as CTRL+~)
It should use function e.g. REPLACE, SUBSTITUTE etc at B1 for my backup,
instead of CTRL-F + ALT-P to replace.
There is Cell A1:
=1+2+3+4
how to remove "=" so that Cell B1 is:
1+2+3+4
(NB. it is not same as CTRL+~)
It should use function e.g. REPLACE, SUBSTITUTE etc at B1 for my backup,
instead of CTRL-F + ALT-P to replace.
Last edited by london7871; 11-16-2017 at 06:24 AM.
You could use the Find/Replace dialog and simply replace = with nothing.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hello, You can use below formula in B1 to get your desired result.
Formula:Please Login or Register to view this content.
Regards,
Thangavel D
Appreciate the help? CLICK *
Thanks Thangavel D, it's solved.
Also thanks to xlnitwit for advice.
FORMULATEXT() Applies To: Excel 2016 Excel 2013 Excel 2016 for Mac Excel for Mac 2011 Excel Online
it doesn't exist in Ex2003 so update your profile about Excel version
As another CPU have excel 2003 only, please advise how to remove "=" without using "FORMULATEXT".
Hello,
In excel 2003 version, you can do this creating UDF. use the below code:
Please Login or Register to view this content.
you can try this one:
Please Login or Register to view this content.
- Alt + F11
- Insert > Module, and paste the following code in the Module Window
- Usage: =ShowFormula(A1)
edit:
if you want without equal sign, use SUBSTITUTE()
Formula:Please Login or Register to view this content.
Last edited by sandy666; 11-23-2017 at 01:20 AM.
Under excel in office 365,
if cell A1 is =1+1
both the following at cell B1 give "#NAME? :
=ShowFormula(A1)
=SUBSTITUTE(ShowFormula(A1),"=","")
How to solve this? (as I prefer not to use VBA)
Without using VBA (or XLM) a manual replace is the only option I am aware of.
decide what you want to use!!!
it works under 2016 64-bit so should work on 365 too.Please Login or Register to view this content.
showformula.jpg
I tried it on Ex97 (older than 2003) and it works also
showformula97.jpg
I you want for both version use VBA or see and use way from post#10
Last edited by sandy666; 11-23-2017 at 04:22 AM.
My excel cannot use ShowFormula(A1) as attached pdf. Please advise.
did you put this code into module window?
module.jpg
module2.jpg
Last edited by sandy666; 11-23-2017 at 05:02 AM.
Did you use the code in Module or in worksheet?
I have not used the code in Module or in worksheet.
It is better not to use the code or VBA as my excel will be sent to other users with excel 2003.
VBA works on all version.
You didn't read carefully my posts.
If you don't want VBA re-read post#10 (and write instruction to others: how to see formula )
edit:
one more thing - if you want to see formula in-cell, select cell with formula, hit F2 and you will see it, after that hit Escape (Esc) to hide formula without changing.
should work on all version of excel
Last edited by sandy666; 11-23-2017 at 05:27 AM.
Thanks than_gold, sandy666 and xlnitwit for suggestion.
Yes, Excel 2008 was a Mac version, but the VBA restrictions I mentioned usually apply to Windows versions.
So, info about MS-Off Ver: in profile should contain more details, ie. PC 2010 Starter (wishful thinking)
Perhaps but that wouldn't help if the user has, say, Office Professional Plus but his/her IT department have blocked VBA.
But we are talking about VBA and excel version not about IT Dept.
IT Dept. can prohibite save as also and many other features, in effect high ver. of excel will be very low version
They can say: you've paper and Excel is not needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks