How to add a number that appears in a string of text

[Burrgogi]

Let's say for example in Cell A500, I have the following:
"Total for Col. A: 360"

I update this number manually every time I had a new item in col. A (sometimes this list changes on a monthly basis). What I'd like to do is take whatever number it happens to be and add 171.

In a different cell, I would like the following:

Total Effective Count xxx (DLCs only). Where XXX equals whatever appears in cell A500+171. If there's a formula for this, I would appreciate some help. Thanks.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
20	Total for Col. A: 360		Total Effective Count 531 (DLCs only)
Main

Cell Formulas
Range	Formula
C20	C20	="Total Effective Count "&MID(A20,FIND(":",A20)+1,99)+171 &" (DLCs only)"

 

[Burrgogi]

That works. Thanks as always Fluff.

 

[Fluff]

Glad to help & thanks for the feedback.