Controling long text fields

[Bruce927]

How do I Concatenate different fields so that they appear in paragraph format in lieu of one continuous string. I have a spread sheet that I am trying to convert to a database. The information in the spread sheet may contain several rows of text for one record. Each Row has two columns of text. I need to take the text from these multiple columns and Rows into one long text field.
To try to keep my explanation easy to follow let us say in the spread sheet I have two rows for the same record, a work brief field, and note field. I want to combine the 4 text fields into one. I would need to combine in this order Work brief 1 then note 1, then work brief 2 then note 2, with a line break order listed below.

Work brief 1
note 1
Work brief 2
note 2

[PhilOfWalton]

Use something like

Field1 & VbCrLF & Field2 & VbCrLF & Field3 & VbCrLF & Field4
 

VbCrLf is a carriage feed.

Not that if you are trying to save these 4 fields as 1 new field in a table, there is a limit of 255 characters for text field, so you may need to use a memo (Long Text) field.

Phil

[NeoPa]

Hi Bruce.

You also need to consider what data is there in your spreadsheet to allow you to determine which Rows in Excel should be grouped together and which should be treated as separate records.