Forum Discussion
Getting SMS from my Excel file for specific dates to my own phone
I have used the following formula in my Excelsheet, in an extra column "B" as under:- =IF(A2=TODAY(),,"C2&D2&E2&F2""") But, it is giving an error message. How do I get over this issue?
Hi ColSaxena
if you want to concatenate the cells, the formula should look like this:
=IF(A1=TODAY();C2&D2&E2&F2)
In case A1 is not todays date, it will just return FALSE
Kind regards,
Martin
Thanks dear Mr. Weiss,
In my sheet, A1 is the heading marked Date, & A2 is the first data.
That is why I wrote A2=.
I have not been able to get any method of providing my own phone
in this file.
An Ad In called Excel To SMS, found by google Search, was downloaded.
But it is not getting activated on my system.
could you please help further.
regards,
Col Saxena
- Thanks dearMr. Martin,
In my sheet A1 contains the Heading Date, & the first data is in Cell A2.
I have created another column B, in which I am entering this formula.
But, I have not been able to add or integrate any SMS service in this
file, nor enter my own phone number.
The AD In Excel To SMS, found
