TheyCallMeNerd
New Member
- Joined
- Dec 13, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello
Recently I have started in a new position. I am an intermediate to advanced user of Excel and my VBA skills are minimal at best. So, I would like to avoid VBA if at all possible.
On to the question: I have a spreadsheet that is set up with account codes with the following format: ##-####-#### Department/Division/Account.
Department Division Account
Column A Column B Column C Desired Results(Column D)
00 0000 0000 00-0000-0000
1111 00-0000-1111
2222 00-0000-2222
1111 0000 00-1111-0000
1111 00-1111-1111
2222 00-1111-2222
3333 00-1111-3333
4444 00-1111-4444
01 0000 0000 01-0000-0000
1111 01-0000-1111
2222 01-0000-2222
1111 0000 01-1111-0000
1111 01-1111-1111
2222 01-1111-2222
I would like to create a formula that will concatenate all of these into the above listed format? Is this even possible? The information is a data dump from Report Server.
I do believe it would be nested IFS Statement. It is the lookup part that I am not sure which would be best. Index/Match or VLookup or XLookup. Any input would be greatly appreciated!
Recently I have started in a new position. I am an intermediate to advanced user of Excel and my VBA skills are minimal at best. So, I would like to avoid VBA if at all possible.
On to the question: I have a spreadsheet that is set up with account codes with the following format: ##-####-#### Department/Division/Account.
Department Division Account
Column A Column B Column C Desired Results(Column D)
00 0000 0000 00-0000-0000
1111 00-0000-1111
2222 00-0000-2222
1111 0000 00-1111-0000
1111 00-1111-1111
2222 00-1111-2222
3333 00-1111-3333
4444 00-1111-4444
01 0000 0000 01-0000-0000
1111 01-0000-1111
2222 01-0000-2222
1111 0000 01-1111-0000
1111 01-1111-1111
2222 01-1111-2222
I would like to create a formula that will concatenate all of these into the above listed format? Is this even possible? The information is a data dump from Report Server.
I do believe it would be nested IFS Statement. It is the lookup part that I am not sure which would be best. Index/Match or VLookup or XLookup. Any input would be greatly appreciated!