vba_student
New Member
- Joined
- Dec 20, 2016
- Messages
- 2
Hi All,
First time poster, but a huge fan of the forum and have received tremendous assistance from past posts in my work - I don't know where I would be without the help from this community.
I am in need of a simple VBA code to execute cut and paste based on the number of characters in a cell and repeat for each row.
The Data appears as follows:
P Q R
12345678 Calculate Account
More specifically, based on my requirements in the above data:
1. Count the number of characters on column P
2. If it's less than or equal to 8 characters THEN;
3. Cut and paste the contents in column P and Q over to the right one cell.
4. Repeat for each row
In the end, I'd like the Data to appear as follows:
P Q R
12345678 Calculate Account
Some caveats:
1. The data is in text format (not sure if this will have an impact).
2. The data is in a formatted table, which I already see won't take the function - LEN(text).
Many Thanks in advance!
First time poster, but a huge fan of the forum and have received tremendous assistance from past posts in my work - I don't know where I would be without the help from this community.
I am in need of a simple VBA code to execute cut and paste based on the number of characters in a cell and repeat for each row.
The Data appears as follows:
P Q R
12345678 Calculate Account
More specifically, based on my requirements in the above data:
1. Count the number of characters on column P
2. If it's less than or equal to 8 characters THEN;
3. Cut and paste the contents in column P and Q over to the right one cell.
4. Repeat for each row
In the end, I'd like the Data to appear as follows:
P Q R
12345678 Calculate Account
Some caveats:
1. The data is in text format (not sure if this will have an impact).
2. The data is in a formatted table, which I already see won't take the function - LEN(text).
Many Thanks in advance!