Hi, as title says i cant seem to easily delete some blanks and it would take alot of time to do it manually. ive tried using go to special to select just the blanks but it returns none found.
ive tried to attatch the file in question but cant seem to figure out how
to attach a file use the "go advanced" below this window then midway down use manage attachments then browse to the file, upload, ok, ok and that should work.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sorry should of said, i ge tto manage attatchments and upload it but the attatchment button in text edditor is blank. i can tell its uploadded by going the relevnt page in settings.
You need to click Go Advanced below the reply window first. Then scroll down below that to Manage attachments.
Dave
i know how to navigate to manage attatchments, figured that out before i posted here. i upload the file but when i click on the attatchments button in the text edditor it doesnt show the upload.
i have no idea what happened there, and i would edit that post instead of posting again but dont want to risk removing the attatchment.
Need a bit more details. Which sheet are you referring to in post#1? Which cells are you trying to delete? Delete? or Clear contents? Need some specifics here. We are not mind readers and don't really know what you are doing? By the way, if a cell has a formula in it but the value in the cell is "", then that is not blank. A blank has nothing in it. So please clarify what you are attempting.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
the first two sheets have the info put in. the first is probably the best to use as an example, its all the black cells (done using conditional formating). i want to delete those cells and move the rest to the left. and i guess it would be the "" cells then, sorry want aware it was distinctly diffrent from a blank cell.
i manadged to figure it out. had to use find and replace looking in formulas to replace the "" that was making the blanks with something unique i could use the find function for, then using that found all that were intended to be deleted hit ctrl+a to select all and then just right click and delete.
sorry for wasting anyones time and if i was snippy earlier.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks