non number consolidation

[Jason Sands]

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.

 

[Pete_UK]

Try this:

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

Copy down as required.

Hope this helps.

Pete