richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 69
- Office Version
- 2016
- Platform
- Windows
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.
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.