Excel String Concatenation Question

Question

For example, I have

40572 in A1. However, it is set to "Date", so what I see is actually 1/29/2011
888 in B1. Nothing fancy.

=A1&B1 in another cell. It shows 40572888.

However, what I want to see is 1/29/2011888 while still having 40572888 in the values. So that the first 5 digits are viewed as "Date" and the rest as "General". I don't want to use "=TEXT" because it doesn't preserve the value 40572. Is this possible?

Formatting is by cell in Excel; one cell cannot include both date-formatted and general-formatted values. Since you are concatenating these values, the contents of the cell will be treated as text no matter what. — Excellll
– Excellll, Commented Jul 14, 2011 at 14:07

powerMicha · Accepted Answer · 2011-07-14 11:28:58Z

1

Did you try via CONCATENATE

Example:

A1 = 1/29/2011
B1 = 888 
C1 = CONCATENATE(TEXT(A1, "MM/DD/YYYY"), " ", B1)

Please try on your own, because my excel is only available in german ;)

Btw: what do you mean with

it doesn't preserve the value 40572

edited Jul 14, 2011 at 11:28

answered Jul 14, 2011 at 11:14

powerMicha

2,7731 gold badge25 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gaijinhunter Over a year ago

You need to use commas instead of ";". Should be "=CONCATENATE(TEXT(A1, "MM/DD/YYYY"), " ", B1) or take out the second part if you don't want to space seperator between the two.

Collectives™ on Stack Overflow

Excel String Concatenation Question

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related