Using Texts in Cells

D

Duncan

I have a list of parts numbers (alphabetical and numeric) and want to use
these in a sum.
How can I include these in a sum eg if C1= EV1, C2=EV2?
Alternatively if not possible can I use the SUBSTITUTE function to pick this
text from a list
Thanks in advance
 
D

Duncan

I want to show the text:
eg the column looks like;
o
o
EV-R4
0
0
So I want the cell below to show the text, so I can use it in a product
selection guide
Thanks
 
B

bj

most of the time people would call this concatinating rather than summing

if C1= EV1, C2=EV2
=C1 & "-" & C2
or
= Concatinate(C1,"-",C2)
would result in
EV1-EV2
 
D

Duncan

Thanks I have done it

bj said:
most of the time people would call this concatinating rather than summing

if C1= EV1, C2=EV2
=C1 & "-" & C2
or
= Concatinate(C1,"-",C2)
would result in
EV1-EV2
Click to expand...
 
Top