non number consolidation
 

Hello group. I have attempted to consolidate fields with no luck. The
first field column I have changed to Store, so I can insert it into my
address book. The second column is the store name, the third column is
the store number (not telephone), and the fourth column is the store
account number.

e.g.
Store StoreName WarehouseStoreNumber StoreAccount
I would like for them to be consolidated with a dot (.) in between all
fields, like:
Store.StoreName.WarehouseStoreNumber.StoreAccount

Thanks in advance.
Jason.

non number consolidation
 

Try this:

=A2&"."&B2&"."&C2&"."&D2

Copy down as required.

Hope this helps.

Pete

On Oct 28, 6:33*pm, Jason Sands wrote:
Hello group. I have attempted to consolidate fields with no luck. The
first field column I have changed to Store, so I can insert it into my
address book. The second column is the store name, the third column is
the store number (not telephone), and the fourth column is the store
account number.

e.g.
Store StoreName WarehouseStoreNumber StoreAccount
I would like for them to be consolidated with a dot (.) in between all
fields, like:
Store.StoreName.WarehouseStoreNumber.StoreAccount

Thanks in advance.
Jason.