CODEWITHSUNDEEP
excel
Mariska
Mariska

Reputation: 1953

Excel String Concatenation 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?

Upvotes: 0

Views: 1441

Answers (1)

powerMicha
powerMicha

Reputation: 2773

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

Upvotes: 1

Related Questions