AT&T Step Processes

No Customization

1. Load list in Excel and check email column for duplicates and remove all duplicates
2. Upload list to TM
3. Export the report of UnSubs (this will create the PreUnSub list

Customizations

Last 4 Digits of Ban

1. Load list in Excel and create a new column
2. in the new column you can add in the cell `=RIGHT(B2,4)` (Replace B with the column with the BAN Numbers =TEXT(RIGHT(B2,4),"0000")

1. Use the new column when uploading to TM for the BAN number

Combining Numbers to One line

1. if it is a small amount you can copy and paste
2. for large amounts you might need a formulate similar to below:

`=INDEX($D$2:$F$5, INT((COLUMN()-COLUMN($G$1))/COLUMNS($D$2:$F$5))+1, MOD((COLUMN()-COLUMN($G$1)), COLUMNS($D$2:$F$5))+1)`

Add - to numbers (123456789 => 123-456-789)

`=CONCAT(LEFT(C2,3),"-",MID(C2,4,3),"-",RIGHT(C2,4))`

1. With the results you can copy and use the option to paste values in so you have the values and not the calculations in the cells

Combine CELLS to one

`=CONCAT(F12,";",G12,";",H12)`

1. With the results you can copy and use the option to paste values in so you have the values and not the calculations in the cells

Lower case

=LOWER(A2)

Proper Case

=PROPER(A2)

Find Matches

If you have to columns of data and trying to find a match you can create an addition column and use this equation

=IF(COUNTIF(B:B, C2)>0, "Match", "No Match")