excel01noob
Board Regular
- Joined
- Aug 5, 2019
- Messages
- 93
- Office Version
- 365
- 2016
Using data from source Worksheet to filter as per defined criteria I want after to copy the column of accounts IDs (column A) and paste them into the destination worksheet but with a slight different format
In the account IDs I check the length: if equal to 4 digits such as 1234, copy the account and paste in destination column D as F1234, if more than 4 digits as 4592482, copy and paste as X4592482
How to achieve this?
In the account IDs I check the length: if equal to 4 digits such as 1234, copy the account and paste in destination column D as F1234, if more than 4 digits as 4592482, copy and paste as X4592482
How to achieve this?