**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have 500 numbers in column A with aproximatly 15digits.
In column B I have 5 numbers with 6 digits
Can a find a formula wich can transfer all numbers from A column wich start with some 6 digitsa from B column

Solved by V. L. in 32 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
25/03/2018 - 11:43

2013

User
25/03/2018 - 11:43

more than 1 hr

Excelchat Expert
25/03/2018 - 11:44

Hello

User
25/03/2018 - 11:44

can I show on the scree here like example what I need?

User
25/03/2018 - 11:44

hello

Excelchat Expert
25/03/2018 - 11:44

So can you share the file

Excelchat Expert
25/03/2018 - 11:44

Yes sure

User
25/03/2018 - 11:44

no

User
25/03/2018 - 11:44

ok I'll show

User
25/03/2018 - 11:44

1 min

User
25/03/2018 - 11:45

like that

User
25/03/2018 - 11:45

but my column]

User
25/03/2018 - 11:45

A

User
25/03/2018 - 11:46

is very big

User
25/03/2018 - 11:46

every day

User
25/03/2018 - 11:46

Is hard to fiind everytime

User
25/03/2018 - 11:46

I need a formula who can find all numbers from A wich start with B numbers

User
25/03/2018 - 11:46

and transfer in C ALL

User
25/03/2018 - 11:46

all

Excelchat Expert
25/03/2018 - 11:47

Hmm, I see

User
25/03/2018 - 11:47

I think is VLOOKUP here

Excelchat Expert
25/03/2018 - 11:47

how many numbers are there in B?

User
25/03/2018 - 11:48

every day different

User
25/03/2018 - 11:48

t aproximatly 20

User
25/03/2018 - 11:49

and in A column can be 500 or 1000

Excelchat Expert
25/03/2018 - 11:49

let me think a bit

User
25/03/2018 - 11:49

ok

User
25/03/2018 - 12:04

sorry, are you still here?

Excelchat Expert
25/03/2018 - 12:06

yes, just wait a bit more

User
25/03/2018 - 12:06

ok sorry

Excelchat Expert
25/03/2018 - 12:13

here

[Uploaded an Excel file]

Excelchat Expert
25/03/2018 - 12:14

there are two extra columns D and E

Excelchat Expert
25/03/2018 - 12:14

You can hide those

Excelchat Expert
25/03/2018 - 12:14

So what D is doing is extracting the first 6 digit of A

Excelchat Expert
25/03/2018 - 12:15

and after that I am copy pasting D in E as "Values"....

User
25/03/2018 - 12:15

ok thank you very very much

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*