I have a data set that looks like: 9018.010.00008 9018.010.00007 (Blank) (Blank) (Blank) AKM32C-ACC2R-00 (Blank) 152.01.100 I want it to look like: 9018.010.00008 9018.010.00007 AKM32C-ACC2R-00 152.01.100

<blockquote><div class=”vibrantContent”><center><div itemprop=”video” itemscope=”” itemtype=”http://schema.org/VideoObject”><iframe src=”/web/20201026153629if_/https://www.computing.net/img/screencast/play.html#382045-57″ height=”270″ width=”480″ marginwidth=”0″ marginheight=”0″ hspace=”0″ vspace=”0″ frameborder=”0″ scrolling=”no” allowfullscreen=”true” webkitallowfullscreen=”true” mozallowfullscreen=”true” style=”max-width: 95%; margin-top: 8px; border: 1px solid rgb(226, 226, 226); visibility: visible;” data-dashlane-frameid=”1062″></iframe><div style=”font-size: 11px; font-style: italic;”><meta itemprop=”contentURL” content=”http://bom-computing-screencasts.s3-website-us-east-1.amazonaws.com/screencasts/382045-57.mp4″><meta itemprop=”thumbnail” content=”/img/screencast_splash.jpg”><span itemprop=”name”>I want ...

Hi at 68 I’m not to clever with things like Excel unless quite basic. My problem at the moment living in my motorhome and based a lot of the time in Napier, NZ for part time work. Napier only allow ...

File updates the current date but I also need the current date +30 days later in the doc. As in “Please return your documents by (30 days after today)”

I am looking to do something similar to a Vlookup, but I have 9 sheets through which I want excel to look. Basically, I have a list of names with data that carries through 9 sheets, and then a shorter ...

My microsoft word documents are printing out really tiny in the left hand corner the page (it looks kind of like a thumbnail of the image on the screen). Everything else prints fine so I know it’s a problem with ...

Hi, I am having a problem summing up the values of a Vlookup results. In my particular case I have a monthly sheet that has codes of items purchased in that month along with the corresponding item and the cost in ...

I want a formula that will return a blank if there is no date and the exact date if there is one. Let’s say A! will eventually have a date and the cell is formatted as date, but I do ...

Hello, I have a workbook in excel with a number of different worksheets. I would like a way to set it so that when a user prints the workbook it only prints specific pages based on whether a specific cell in ...

I need to create a spreadsheet which will show clashes, i am an administrator timetabling and i need a sheet which will pick up room/student clashes. I am using a sheet created by another locality which has been set up ...