Concatenate

[richmcgill]

I have four cells of data and I need to keep the formatting for two of the cells. I also need a ; between the sets of data.
cell a2 is a number a 1 or 2
cell b2 is 012345678 (this is a SSN without the dash's in between the numbers) need to keep all nine digits even if the leading numbers are zeros.
cell c2 name of person
cell d2 0012345678 (loan number) need to keep all 10 digits even if the leading numbers are zeros.

Should look like this
2;012345678;Persons Name;0012345678

The SSN and Loan Number need to keep the format.

 

[Fluff]

HI what version of Excel are you using?

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[richmcgill]

2016

 

[Fluff]

Ok, two options depending on whether B2 & D2 are text with leading 0, or are numbers formatted to show leading 0s

+Fluff v2.xlsm
	A	B	C	D	E
1
2	1	012345678	Fluff	0012345678	1;012345678;Fluff;0012345678
3	1	12345678	Fluff	0012345678	1;012345678;Fluff;0012345678
4
Sheet2

Cell Formulas
Range	Formula
E2	E2	=A2&";"&B2&";"&C2&";"&D2
E3	E3	=A3&";"&TEXT(B3,"000000000")&";"&C3&";"&TEXT(D3,"0000000000")

 

[richmcgill]

That you!!!

 

[Fluff]

You're welcome & thanks for the feedback.