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
Hi
User
08/12/2017 - 03:07
Hi
Excelchat Expert
08/12/2017 - 03:07
Can you please let me know which formula you are using
User
08/12/2017 - 03:07
vlookup
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
01022106
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
yes
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
=if(len(A6)=7,"0"&A6,A6)
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.