Concatenate Columns

[jweislak@xbs-toledo.com]

I have some customers that email spreadsheets of three and four columns that I need all the information in one column.

Such as:

Column 1; Column 2; Column 3
Last name, First name; Social Security #; Date

I need this information to appear as one column as follows:

Last name, First name; Social Security; Date

This will then be cut and pasted in to an access database.

Thank you,
Jennie

Jennifer J. Weislak
XEROX Business Services
jweislak@xbs-toledo.com
419-248-7336
This message was edited by jweislak@xbs-toledo.com on 2002-05-10 07:40

 

[Aladin Akyurek]

On 2002-05-10 07:39, jweislak@xbs-toledo.com wrote:
I have some customers that email spreadsheets of three and four columns that I need all the information in one column.

Such as:

Column 1 Column 2 Column 3
Last name, First name Social Security # Date

I need this information to appear as one column as follows:

Last name, First name; Social Security; Date

This will then be cut and pasted in to an access database.

Thank you,
Jennie

Jennifer J. Weislak
XEROX Business Services
jweislak@xbs-toledo.com
419-248-7336

Last name, First name; Social Security; Date

=A1&", "&B1&"; "&C1&"; "&D1

Give a double click on the fill handle of the formula cell.

Just curious: Why would you reduce all this into a compound field in a database?

Aladin

 

[jweislak@xbs-toledo.com]

Alan,

The company that I work for wants it that way I prefer it separated they do not.

Thank you for your help I will try this I was having trouble with the number factors.

Jennie

 

[Aladin Akyurek]

On 2002-05-10 07:50, jweislak@xbs-toledo.com wrote:
Alan,

The company that I work for wants it that way I prefer it separated they do not.

Thank you for your help I will try this I was having trouble with the number factors.

Jennie

You mean the date thing I guess. Darn it. Make that concat formula:

=A1&", "&B1&"; "&C1&"; "&TEXT(D1,"mm/dd/yy")

Adjust to suit the last part.

Cheers.

Aladin