Replace with condition

[ahmed Adel]

If the first initial or number = 2 replace it with 3099 and if 5 replace with 5440 any other number should stay with no effect

For ex
25756556756 should be 3099 cause starts with 2
24445556 should be 3099

36345 should be 36345

5383737 should be 5440

 

[Cubist]

You can use a combination of IF and LEFT.

Book1
	A	B
1
2	25756556756	3099
3	24445556	3099
4	36345	36345
5	5383737	5440
Sheet5

Cell Formulas
Range	Formula
B2:B5	B2	=IF(--LEFT(A2,1)=2,3099,IF(--LEFT(A2,1)=5,5440,A2))

 

[ahmed Adel]

بالضبط هذا ما فعلته شكرا لك

 

[Fluff]

Please post to this forum in English only. Thanks.