help: sort from z to a for range

[emadtira]

dear,

i want to sort arange from cell G25 to G45 IN COLUMN D And expand selection for other columns but i want the sorting process to be within the range from g25 to g45 and not affect the cells above and below that range.

second question: i need formula that say if any value (text,number,etc..) is in cell then condition.

thankyou

 

[Domski]

You can sort a specific range by just selecting it and using Data...Sort. Excel may ask if you want to expand the selection but you just say no.

Not sure what you mean by your second question.

Dom

 

[emadtira]

second question is:
i need to say if cell a4 contains any type of data then yes, if not then no

=if(a4=any type of data,yes,no)

thank you for your time

 

[Jonmo1]

Try

=IF(LEN(A1)>0,"yes","no")

 

[emadtira]

dear,

thank you for help

i need to add condition in IF formula exists in cell a4 that says, if the result of the formula is 0 then type ---

i mean when the result of formula is 0 change 0 to ---

thankyou

 

[Jonmo1]

Try

=IF(A4=0,"---",A4)