Hello,
I have data coming in from a form and will need to be updated regularly - I was hoping to create a macro that combines the data for those needing it. Once imported, I will have an excel file that has phone numbers and carriers (eg TMobile, ATT etc). In order to send texts, we need to create a new column that combines the phone number with the correct @ (eg. if the carrier is tmobile it needs to be @tmomail.net, if Sprint it needs to be @messaging.sprintpcs.com, etc).
To clarify:
Column C: 1112223333 Column D: carrier I Need Column E: 111222333@specificcarrier.com
I have tried an if/then syntax, which didn't work (and it makes sense that it didn't work now that I am looking at it...)
=C1&(if D1=tmobile[@tmomail.net],[], if D1=ATT [@messaging.sprintpcs.com],[])
So, the questions I have - first, do I need to have the macro change all of the phone numbers to string/text first and then use the "&" function? How do I indicate that if the second column is not tmobile or att, then to consider if it is verizon etc.? Also, the @ symbol seems to give excel fits (but that may be the formula and not the symbol). I think I may be making this much more difficult than it should be. Any suggestions?
Does this make sense? Thank you for any help that you can give me!
I have data coming in from a form and will need to be updated regularly - I was hoping to create a macro that combines the data for those needing it. Once imported, I will have an excel file that has phone numbers and carriers (eg TMobile, ATT etc). In order to send texts, we need to create a new column that combines the phone number with the correct @ (eg. if the carrier is tmobile it needs to be @tmomail.net, if Sprint it needs to be @messaging.sprintpcs.com, etc).
To clarify:
Column C: 1112223333 Column D: carrier I Need Column E: 111222333@specificcarrier.com
I have tried an if/then syntax, which didn't work (and it makes sense that it didn't work now that I am looking at it...)
=C1&(if D1=tmobile[@tmomail.net],[], if D1=ATT [@messaging.sprintpcs.com],[])
So, the questions I have - first, do I need to have the macro change all of the phone numbers to string/text first and then use the "&" function? How do I indicate that if the second column is not tmobile or att, then to consider if it is verizon etc.? Also, the @ symbol seems to give excel fits (but that may be the formula and not the symbol). I think I may be making this much more difficult than it should be. Any suggestions?
Does this make sense? Thank you for any help that you can give me!