Hi Roger
Thank you very much for your swift and usuful solution and reply, I
used the left formula with if fuction. I have a problem, and it is
always the same, when I nest if function, it always give error formula,
no matter I check the brackets, and I just wrote exactly the formula of
if function in the help menu (not copy, write), and check it still
gives error, I have the impression that I am missing some information
about this nested functions, thanks in advance for help
Regards
Jam

Roger Govier wrote:
Hi

Not quite sure what you are after here.
Do you want
=IF(LEFT(A1,6)="Pay to","Salary","")
or
=IF((--(MID(A1,8,2))=23,"Salary","Bonus")

--
Regards

Roger Govier


"jam" wrote in message
oups.com...
Hi
I want to do this:
A B
Pay to 23 people 2006 Salery
Pay to 10 people 2006 Bonus
I want the column B to have the same string "salery" every time I
write
pay to...
in order to filter at the end and make a balance
Using if, and nested if does not give the same string if I change the
number 23 to 50 for example
Any help? I would be grateful
Jam