Copy the number matched to another column [Closed]

Report
Posts
2
Registration date
Thursday May 5, 2016
Status
Member
Last seen
May 5, 2016
-
Posts
2
Registration date
Thursday May 5, 2016
Status
Member
Last seen
May 5, 2016
-
Hello,

I want help from world.i want to copy the list of number to other column which are match in original column.
Start no 974314567 copy the no which is first 4 numbers match to another column .if 9743 match then copy the whole no 974314567 in another column.if not do not copy . Thanks pls anyone help me.

2 replies

Posts
2
Registration date
Thursday May 5, 2016
Status
Member
Last seen
May 5, 2016
1
Thanks a lot , these are the column list of numbers
examples
9743134567
9744556765
9743245675
9744567890
9743123456

I want to copy the numbers in another new column like this which match from the first 4 digits 9743

9743134567
9743245675
9743123456
I hope to get the solution pls.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,816
Sorry we have no idea what you are trying to do.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!