Adding a number to a cell with numbers and text

[Kurt]

I have a cell AH3 that shows $3.31/Qty

Can someone show me how to add let's say a 1 to make it $4.41/Qty to keep the text together or does the text need to be split apart temporarily?

Is there another way to do this?

 

[jtakw]

Hi,

If you mean result in another cell:

Book1
	E	F
1	$3.31/Qty	$4.31/Qty
Sheet520

Cell Formulas
Range	Formula
F1	="$"&LEFT(E1,FIND("/",E1)-1)+1&MID(E1,FIND("/",E1),99)

 

[Kurt]

Hi,

If you mean result in another cell:

Book1
	E	F
1	$3.31/Qty	$4.31/Qty
Sheet520

Cell Formulas
Range	Formula
F1	="$"&LEFT(E1,FIND("/",E1)-1)+1&MID(E1,FIND("/",E1),99)

This almost works but I need this number format #,###.00 and /Qty include with the number in cell AH3 like 4.41/Qty

Can someone please help me finish this out?

 

[Kurt]

My bad this does indeed work I had to change all references to cell E1.

Now is there a way to have this formula in a drop down list with the values of 1, 1.5, 2, 2.5, 3, 3.5, 4 ??

 

[jtakw]

I do not understand your latest question, please explain in detail with samples.