By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 2,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

Controling long text fields

P: 23
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
Dec 12 '17 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,430
Use something like
Expand|Select|Wrap|Line Numbers
  1. 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.

Dec 12 '17 #2

Expert Mod 15k+
P: 31,494
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.
Dec 13 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.