Hello all,
Hoping someone would know the answer
I would like to copy and paste data within the same sheet like below.
Company: ABC123 in cell A1
I would like to copy the last 6 characters in this string meaning the characters starting from A.
Assume theres data in rows 2 through 4 in columns A B and C. Row 5 is blank.
I would like to paste the data as paste values in column D starting in 2 and stop when it reaches a blank row. Meaning the paste values should stop in row 4.
Hope my description is clear.
Thanks in advance.
Hoping someone would know the answer
I would like to copy and paste data within the same sheet like below.
Company: ABC123 in cell A1
I would like to copy the last 6 characters in this string meaning the characters starting from A.
Assume theres data in rows 2 through 4 in columns A B and C. Row 5 is blank.
I would like to paste the data as paste values in column D starting in 2 and stop when it reaches a blank row. Meaning the paste values should stop in row 4.
Hope my description is clear.
Thanks in advance.