Listware for Excel:MatchUp:Input Columns: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
Created page with "{{LWEMatchUpNav |StepsCollapse= }} {{CustomTOC}} link= Specify the input columns you want to process by selecting them in the drop-dow..."
 
No edit summary
Line 10: Line 10:


The following input columns are available:
The following input columns are available:
==Name==
;Full Name
:Specify the column that contains full names.
;First Name
:Specify the column that contains first names.
;Last Name
:Specify the column that contains last names.




==Address==
==Address==
;Company
:Specify the column that contains company and/or organization names.
;Address
;Address
:Specify the column that contains street or PO Box addresses.
:Specify the column that contains street or PO Box addresses.
Line 35: Line 43:
;ZIP Code
;ZIP Code
:Specify the column that contains the US ZIP code and/or Canadian Postal Code.
:Specify the column that contains the US ZIP code and/or Canadian Postal Code.
==Phone==
;Phone
:Specify the column that contains phone numbers.
==Email==
;Email
:Specify the column that contains emails.




[[Category:Listware for Excel]]
[[Category:Listware for Excel]]

Revision as of 19:30, 9 September 2016

← Listware for Excel Reference

MatchUp Navigation
← Listware for Excel Overview
Overview
Tutorial
Steps
Processing Range
Options
Input Columns
Output Columns
Reporting
Review Settings
Processing
Processing Results
Result Codes



Specify the input columns you want to process by selecting them in the drop-down menus.

The following input columns are available:


Name

Full Name
Specify the column that contains full names.
First Name
Specify the column that contains first names.
Last Name
Specify the column that contains last names.


Address

Address
Specify the column that contains street or PO Box addresses.
Address 2
Specify the column that contains a second address line. If available, this is generally extra addressing information such as an apartment or suite numbers.
If the information is in the "Address" column, it will be found and parsed to this column when you specify that column here.
Address 3
Specify the column that contains any additional address information not already included in the first two address lines.
City
Specify the column that contains cities.
State
Specify the column that contains the US state and/or Canadian province.
ZIP Code
Specify the column that contains the US ZIP code and/or Canadian Postal Code.


Phone

Phone
Specify the column that contains phone numbers.


Email

Email
Specify the column that contains emails.