Hi all

I must tell this is the first time I am working with FMP.

I have exported an excel file which has contact address of many persons. However, each field/(column in excel) is like Title,name,surname,address etc. I was wondering can I merge all of them into one new field as address.

Thanks for much needed help.

S

You have 3 method to merge.

Firts one is in layout mode. Enter Layout mode and sellect Merge Field from insert menu (Cmd + M) then select name filed, repeat same command and select surname and adress fields. In this method in browse and preview mode the filed are placed like merged. But with this method you can not enter new records datas in marged type (You can enter them seperate fields as before but you can see them together)

Second method is creating calculation field. This method is a bit same as first one. You will enter data separate fields but you'll see them marged. To perform this method create new calculation field which has the formula:

Name & " " & surname & " " & adress

third method is replace, create new text field. Then in browse mode place cursor in your new field than select replace field contents from records menu. Replace dialog will be appear. select calculation radio button and type calcuation below:

Name & " " & surname & " " & adress

and click replace button. This method changes your new field value to your desired values but only for current found set.

Adam Djuby