Question description:
This user has given permission to use the problem statement for this
blog.
when pulling data from one worksheet to another, if the original cell is blank it comes through as a "0" of the destination cell. I want it to show as blank
Solved by T. S. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/03/2018 - 01:19
Welcome to excel got it pro.
Excelchat Expert
05/03/2018 - 01:19
I'm here to help you today.
User
05/03/2018 - 01:19
hi
Excelchat Expert
05/03/2018 - 01:20
I understand you want blank if the the other cell is blank, right? What is the formula currently you are using?
User
05/03/2018 - 01:20
a simple "= (cell name)"
Excelchat Expert
05/03/2018 - 01:21
You can wrap the current formula inside a IF formula to make it blank. Let me show you how.
Excelchat Expert
05/03/2018 - 01:22
=IF(A1="","",A1) please look at column B. I have used this formula there.
Excelchat Expert
05/03/2018 - 01:22
Does it make sense?
Excelchat Expert
05/03/2018 - 01:22
If not please ask me.
User
05/03/2018 - 01:23
Yes it does - let me just try it
Excelchat Expert
05/03/2018 - 01:23
Sure, take your time.
Excelchat Expert
05/03/2018 - 01:24
A friendly reminder, we appreciate your feedback on our service. Once we are done, click on the end session button and after that you will be asked for the feedback.
User
05/03/2018 - 01:24
fantastic - just what i was looking for - thank you :-)
Excelchat Expert
05/03/2018 - 01:24
It is important to end session once you no longer need my service, otherwise I won't be able to help others.
Excelchat Expert
05/03/2018 - 01:24
Glad to be in assistance.
Excelchat Expert
05/03/2018 - 01:24
Anything you want to know about the solution?
User
05/03/2018 - 01:25
Nope - i was missing a "" when i was doing it all makes sense now - thank you for your help
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.
