Editing AT&T Step Processes (section)

== 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 =TEXT(RIGHT(B2,4),"0000")

# Use the new column when uploading to TM for the BAN number

=== Combining Numbers to One line ===
# 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) ===
`=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")