Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm trying to take an excel spreedsheet and put it into a goggle and it seems to keep dropping my zero's "0" off from a particular column, yes it is a formula but, is there away to do this without it dropping off the 0?
Solved by B. H. in 14 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/12/2017 - 03:05
User 08/12/2017 - 03:07
Excelchat Expert 08/12/2017 - 03:07
Can you please let me know which formula you are using
User 08/12/2017 - 03:07
Excelchat Expert 08/12/2017 - 03:07
can you copy the lookup range and use formula here
User 08/12/2017 - 03:08
so, I extract data from a ERP system to Excel and I try to take that sheet and copy into goggle sheet tab and it drops off the zeros in front of the part number
Excelchat Expert 08/12/2017 - 03:08
can you share the file here
User 08/12/2017 - 03:09
it's confidential information sorry...
Excelchat Expert 08/12/2017 - 03:09
ok. can you pls share one part number
User 08/12/2017 - 03:09
Excelchat Expert 08/12/2017 - 03:10
it is always "0" at the start?
User 08/12/2017 - 03:10
when we enter these parts into Excel we have to use the 'for it to take the zero of this helps any
User 08/12/2017 - 03:10
85% of parts will start with 0
Excelchat Expert 08/12/2017 - 03:11
number of characters in part number is always 8?
User 08/12/2017 - 03:11
Excelchat Expert 08/12/2017 - 03:12
can you see the formula I entered?
User 08/12/2017 - 03:13
I see you entered items but, not sure what you did
Excelchat Expert 08/12/2017 - 03:13
I am checking length of part number to be 7
Excelchat Expert 08/12/2017 - 03:13
if it is 7, it will add 0 to part number
Excelchat Expert 08/12/2017 - 03:13
otherwise it wont do anything
User 08/12/2017 - 03:14
how do you change it to be 7?
Excelchat Expert 08/12/2017 - 03:14
Excelchat Expert 08/12/2017 - 03:15
instead of A6 in the formula, you can enter Vlookup formula
User 08/12/2017 - 03:16
ok I think this will help me, I'll give it a try today. Thank you this is really cool I can ask for this help.
User 08/12/2017 - 03:16
Have a wonderful day.
Excelchat Expert 08/12/2017 - 03:17
Please check part numbers in cell A6 & A7
Excelchat Expert 08/12/2017 - 03:17
A6 has 7 characters and A7 has 8
Excelchat Expert 08/12/2017 - 03:17
B6 & B7 has the corresponding formula for the cells A6 & A7
Excelchat Expert 08/12/2017 - 03:18
Is it fine?
User 08/12/2017 - 03:18
I'm going to play with it later
Excelchat Expert 08/12/2017 - 03:18
ok Can I end the session now?
User 08/12/2017 - 03:19
Yes, I believe so, thank you again.
Excelchat Expert 08/12/2017 - 03:19
Please leave five star rating if you are satisfied with the solution
Excelchat Expert 08/12/2017 - 03:19
Thank you, have a nice day!!

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc