Copy the number matched to another column

Closed
binoddai Posts 2 Registration date Thursday May 5, 2016 Status Member Last seen May 5, 2016 - May 5, 2016 at 01:02 PM
binoddai Posts 2 Registration date Thursday May 5, 2016 Status Member Last seen May 5, 2016 - May 5, 2016 at 09:41 PM
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 responses

binoddai Posts 2 Registration date Thursday May 5, 2016 Status Member Last seen May 5, 2016 1
May 5, 2016 at 09:41 PM
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
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,825
May 5, 2016 at 05:34 PM
Sorry we have no idea what you are trying to do.
0