Hi!
I have 3 rows of info which i need to create formula's for to do the following:
One column is of mobile numbers some of them are missing a "0" from the front of them. I need to have the old mobile number replaced with the new one with a "0" in front of it.
One column is of email addresses. I need to add a ".au" to 1 group of email addresses with a specific domain.
Another column i have a value and i need it to have 200 removed from the value already existing in the cell if it is over 800 and be replaced with the result of the value-200
I have 3 rows of info which i need to create formula's for to do the following:
One column is of mobile numbers some of them are missing a "0" from the front of them. I need to have the old mobile number replaced with the new one with a "0" in front of it.
One column is of email addresses. I need to add a ".au" to 1 group of email addresses with a specific domain.
Another column i have a value and i need it to have 200 removed from the value already existing in the cell if it is over 800 and be replaced with the result of the value-200