AT&T Step Processes: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== No Customization == # Load list in Excel and check email column for duplicates and remove all duplicates # Upload list to TM # Export the report of UnSubs (this will create the PreUnSub list == Customizations == === Last 4 Digits of Ban == # Load list in Excel and create a new column # in the new column you can add in the cell `=RIGHT(B2,4)` (Replace B with the column with the BAN Numbers # Use the new column when uploading to TM for the BAN number === Combining N...") |
|||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 5: | Line 5: | ||
== Customizations == | == Customizations == | ||
=== Last 4 Digits of Ban == | |||
=== Last 4 Digits of Ban === | |||
# Load list in Excel and create a new column | # Load list in Excel and create a new column | ||
# in the new column you can add in the cell `=RIGHT(B2,4)` (Replace B with the column with the BAN Numbers | # 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") | ||
# Use the new column when uploading to TM for the BAN number | |||
# Use the new column when uploading to TM for the BAN number | |||
=== Combining Numbers to One line === | === Combining Numbers to One line === | ||
| Line 14: | Line 16: | ||
# for large amounts you might need a formulate similar to below: | # 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))` | |||
# 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)` | |||
# 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") | |||
Latest revision as of 06:10, 14 March 2025
No Customization[edit]
- Load list in Excel and check email column for duplicates and remove all duplicates
- Upload list to TM
- Export the report of UnSubs (this will create the PreUnSub list
Customizations[edit]
Last 4 Digits of Ban[edit]
- Load list in Excel and create a new column
- 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")
- Use the new column when uploading to TM for the BAN number
Combining Numbers to One line[edit]
- if it is a small amount you can copy and paste
- 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)[edit]
`=CONCAT(LEFT(C2,3),"-",MID(C2,4,3),"-",RIGHT(C2,4))`
- 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[edit]
`=CONCAT(F12,";",G12,";",H12)`
- 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[edit]
=LOWER(A2)
Proper Case[edit]
=PROPER(A2)
Find Matches[edit]
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")