Make them work on the Each cell Value
Try
=IF(LEFT(A2,1)="1","City","")&IF(LEFT(A2,1)="2","R oskill","")&IF(LEFT(A2,1)="4","Wiri","")&IF(LEFT(A 2,1)="5","Shore","")&IF(LEFT(A2,1)="6","Orewa","") &IF(LEFT(A2,1)="7","Swanson","")&IF(LEFT(A2,1)="8" ,"Panmure","")
I have put & between each pair. & concatenates the strings... The formula
above joins the results of each IF together which gives you the desired answer
_____________________
Click 'Yes' if this helped.
"Steved" wrote:
Hello from Steved
in Cell A1 I have 5854, now picking up the first digit which is 5 it will
type in "Shore"
Please how do I ask the bottom Formulas to do this please
=IF(LEFT(A2,1)="1","City","")+=IF(LEFT(A2,1)="2"," Roskill","") as this method
leaves me a true or false .
=IF(LEFT(A2,1)="1","City","")
=IF(LEFT(A2,1)="2","Roskill","")
=IF(LEFT(A2,1)="4","Wiri","")
=IF(LEFT(A2,1)="5","Shore","")
=IF(LEFT(A2,1)="6","Orewa","")
=IF(LEFT(A2,1)="7","Swanson","")
=IF(LEFT(A2,1)="8","Panmure","")
Thankyou.
|