# Excel - COLUMN Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.