Apply formula to conctenated cell

[revocats10]

I combined values in two colums (A and B) with Concatenate (Column C). Now I want to apply a formula to the combined (Column C). I attached a screenshot of the values. I am not sure how to apply = so that Column C will peform the mathematical operation, as displayed in Column D as an example. Any ideas?Thanks very much.

 

[kweaver]

If it's as straight-forward as the integers from 1 to N being divided by 26, why go through the trouble of the concatenation?

If it's not that straight forward, how about this formula filled down?

=LEFT(C1,FIND("/",C1)-1)/(RIGHT(C1,LEN(C1)-FIND("/",C1)))

 

[revocats10]

If it's as straight-forward as the integers from 1 to N being divided by 26, why go through the trouble of the concatenation?

If it's not that straight forward, how about this formula filled down?

=LEFT(C1,FIND("/",C1)-1)/(RIGHT(C1,LEN(C1)-FIND("/",C1)))

Thanks for the info. I am working on a more involved spreadsheet and adding information. I need to be able do the concatenation as displayed.

 

[Yongle]

I am working on a more involved spreadsheet

Are your your requirements more complicated than detailed in post#1 ?
If s,o please provide a few more examples so that we understand the full extent of your requirements

many thanks

 

[kweaver]

Thanks for the info. I am working on a more involved spreadsheet and adding information. I need to be able do the concatenation as displayed.

So, does my formula work or would you like a VBA solution?

 

[revocats10]

I get a #Value! error when using the method posted above. With regards using the concatenation. I am increasing and decreasing the number of rows in column A (based on the sample size number from another spreadsheet), and then calculating the percent for each row (Column D is an example how I do this in a formula for instance 1/16th, 1/17th, 18th, etc.). By having the concatenation method, I can do this much faster than having to create an updated formula for each row. I can't think of another method to use that is why I was looking to do it this way.

 

[kweaver]

Book1
	A	B	C	D	E
1	1	/26	1/26		0.038462
2	2	/26	2/26		0.076923
3	3	/26	3/26		0.115385
4	4	/26	4/26		0.153846
5	5	/26	5/26		0.192308
6	12	/10	12/10		1.2
7	100	/50	100/50		2
Sheet3

 

[revocats10]

Ok, I had to make some extra steps, but it works. I see you removed the *1, so once I did that and then also adjusted the column/saved as Values (rather then the Concat output), it works. Thanks very much for the help. this will save me a lot of time. I really appreciate it.