Split Excel Cell w/o Text-2-Column?

**benkmann** · 04-07-2008, 03:52 PM

Hi all,

I have a cell that has this in it:

"5+5"

That's how the data arrives to me. I would like to have another cell display the result (i.e. 10) so I won't need to calculate everything by hand. How can I do this with a formula? I don't want to use text-to-columns, and I'd prefer not to use VBA. Thanks!

**NBVC** · 04-07-2008, 04:04 PM

You can give this a try:

go to Insert|Name|Define and enter the word "Evaluation" (without quotes) in the Names in workbook field.

Then in the Refers to field enter formula: =A1 where A1 is the first cell that has an equation to evaluate.

Click Ok.

Now go to the cell next to the one with the equation and enter "Evaluation" (again without quotes).... it should evaluate the equation... you can now copy it down.

**benkmann** · 04-07-2008, 04:32 PM

so this one is the original table...next i'm going to post the steps i took per your reply...didn't work for me

**benkmann** · 04-07-2008, 04:36 PM

untitled 2 - inserted "Evaluation" name, and redirected it to the first cell.

But what do you mean when you say "go to the cell next to the one with the equation and enter "Evaluation""? How do I enter "evaluation" into a cell again?

**NBVC** · 04-07-2008, 04:49 PM

so assuming your equation is in C2 based on the formula you show in the attachment....then go to D2 and just type the word Evaluation...

**benkmann** · 04-07-2008, 04:54 PM

I type the word "evaluation" into the cell? it just displays "evaluation" then. when i try typing "evaluation" into the name field it just re-selects C2...

**NBVC** · 04-07-2008, 05:01 PM

What version of Excel are you in?

Not sure if works in 2007.

If you are in 2003 or earlier, post the sheet and I can look at it tomorrow....

**benkmann** · 04-07-2008, 05:09 PM

see attached.

**benkmann** · 04-07-2008, 05:12 PM

Hi all,

I have a bunch of cells that look like this:

"5+5"

That's how the data arrives to me. I would like to have another cell display the result (i.e. 10) so I won't need to calculate everything by hand. See attached, I tried doing this was formulas but I don't know if it's possible, so i'm looking at VB now.

**oldchippy** · 04-07-2008, 05:35 PM

Hi,

Here's one way to do it with a formula.

**benkmann** · 04-08-2008, 06:20 PM

that equation worked perfectly.

**Stevie-B** · 05-09-2008, 04:45 AM

Originally Posted by oldchippy

Hi,

Here's one way to do it with a formula.

What if I keep adding in extra numbers?

**oldchippy** · 05-09-2008, 05:59 PM

Originally Posted by Stevie-B

What if I keep adding in extra numbers?

Hi,

It won't work if you have more than one "+" between the numbers. You need to give examples, but please start a new thread with your examples

**Stevie-B** · 05-12-2008, 06:26 AM

Originally Posted by oldchippy

Hi,

It won't work if you have more than one "+" between the numbers. You need to give examples, but please start a new thread with your examples

Thanks.

My problem is that every month someone will enter another + and figure as so I would need a count if type formula that would add all numbers within a given cell.