Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
Hello, All In A1 cell I have a text string like "120+130", sometimes more numbers to plus... Could you advice me what formula should I use to replace this with already summarized value. I've tried to use formula "="&A1 but it returnes text value "=120+130"... thanx for assistance -- StanUkr ------------------------------------------------------------------------ StanUkr's Profile: http://www.excelforum.com/member.php...o&userid=27232 View this thread: http://www.excelforum.com/showthread...hreadid=530430 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
Just insert the "=" in the cell itself in the formula bar
-- Kind regards, Niek Otten "StanUkr" wrote in message ... Hello, All In A1 cell I have a text string like "120+130", sometimes more numbers to plus... Could you advice me what formula should I use to replace this with already summarized value. I've tried to use formula "="&A1 but it returnes text value "=120+130"... thanx for assistance -- StanUkr ------------------------------------------------------------------------ StanUkr's Profile: http://www.excelforum.com/member.php...o&userid=27232 View this thread: http://www.excelforum.com/showthread...hreadid=530430 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
One way, may not be what you want though.....
Try Data Text to Columns and select + as the delimiter then sum it as normal. -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "StanUkr" wrote in message ... Hello, All In A1 cell I have a text string like "120+130", sometimes more numbers to plus... Could you advice me what formula should I use to replace this with already summarized value. I've tried to use formula "="&A1 but it returnes text value "=120+130"... thanx for assistance -- StanUkr ------------------------------------------------------------------------ StanUkr's Profile: http://www.excelforum.com/member.php...o&userid=27232 View this thread: http://www.excelforum.com/showthread...hreadid=530430 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
I need to calculate a summ just with the help of a function... the massive of data is too large to insert "=" manualy.... text to column is also not suitable for my purpose... -- Kind regards, Niek Otten "StanUkr" wrote in message ... Hello, All In A1 cell I have a text string like "120+130", sometimes more numbers to plus... Could you advice me what formula should I use to replace this with already summarized value. I've tried to use formula "="&A1 but it returnes text value "=120+130"... thanx for assistance -- StanUkr ------------------------------------------------------------------------ StanUkr's Profile: http://www.excelforum.com/member.php...o&userid=27232 View this thread: http://www.excelforum.com/showthread...hreadid=530430 -- StanUkr ------------------------------------------------------------------------ StanUkr's Profile: http://www.excelforum.com/member.php...o&userid=27232 View this thread: http://www.excelforum.com/showthread...hreadid=530430 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
Use this VBA function:
Function eval(s As String) eval = Application.Evaluate("=" & s) End Function Then you can use this in a cell as: =eval(A1) To install, Alt+F11 to go to the VBA editor. Insert | Module Paste the above code. Ready to use HTH Kostis Vezerides |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
vezerid Wrote: Use this VBA function: Function eval(s As String) eval = Application.Evaluate("=" & s) End Function Then you can use this in a cell as: =eval(A1) To install, Alt+F11 to go to the VBA editor. Insert | Module Paste the above code. Ready to use HTH Kostis Vezerides Thank U! that's exatcly what i need! Custom formula was the best solution here... -- StanUkr ------------------------------------------------------------------------ StanUkr's Profile: http://www.excelforum.com/member.php...o&userid=27232 View this thread: http://www.excelforum.com/showthread...hreadid=530430 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
vezerid Wrote: Use this VBA function: Function eval(s As String) eval = Application.Evaluate("=" & s) End Function Then you can use this in a cell as: =eval(A1) To install, Alt+F11 to go to the VBA editor. Insert | Module Paste the above code. Ready to use HTH Kostis Vezerides Thank U! that's exatcly what i need! Custom formula was the best solution here... -- StanUkr ------------------------------------------------------------------------ StanUkr's Profile: http://www.excelforum.com/member.php...o&userid=27232 View this thread: http://www.excelforum.com/showthread...hreadid=530430 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
So how is it that I can end up getting #NAME?
Always the "black-cloud-following-me", it seems... "vezerid" wrote in message oups.com... Use this VBA function: Function eval(s As String) eval = Application.Evaluate("=" & s) End Function Then you can use this in a cell as: =eval(A1) To install, Alt+F11 to go to the VBA editor. Insert | Module Paste the above code. Ready to use HTH Kostis Vezerides |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I can calculate the value of string "120+150+120... etc"
Never mind, the sun has come out.. LOL
"Jim May" wrote in message news:8C7Zf.55132$KE1.54201@dukeread02... So how is it that I can end up getting #NAME? Always the "black-cloud-following-me", it seems... "vezerid" wrote in message oups.com... Use this VBA function: Function eval(s As String) eval = Application.Evaluate("=" & s) End Function Then you can use this in a cell as: =eval(A1) To install, Alt+F11 to go to the VBA editor. Insert | Module Paste the above code. Ready to use HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Property Let: assign return value of Double when passing String | Excel Discussion (Misc queries) | |||
Browse File for Mac | Excel Discussion (Misc queries) | |||
Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |