plain

Hi..I have a cell in excel which has date '20180907' and when i click the cell it shows 9/7/2018. I would like to convert this cell to plain text and remove the date so it stays as '20180907' and not the date. thanks in advance.

Based on the posts I've reviewed I'm not the only one looking for a STDEVIFS function in Excel. I'm trying to get along without it by using IF and AND. There are two criteria that need to be matched and if they match I want the STDEV. I am trying to get Excel to calculate STDEV for a...

I have a table of which this is an extract: <colgroup><col><col><col><col span="2"></colgroup><tbody> design foreground background size type plain white black XL T-shirt plain white black M T-shirt plain brown yellow L cap paisley blue yellow L cap paisley blue yellow M T-shirt...

Im trying to create a Spreadsheet Template that strips all encoding off of pasted information. Users will copy text and numbers from Web Pages into the Spreadsheet. It will not be feasable to train them on how to ensure they're copying plain text only, as simple as that should be. Microsoft...

Hi I need to analyse many lines of data to see which products get sold together. I though a Pivot table would do the trick but having tried for a while, it doesn't seem to be the answer. So I have a sales orders with products on them. See below. I want to know that Salt & Vinegar has sold...

Hi there, hope someone can help... The names of the worksheets are irrelevant, however I'm keen to know what the following means in plain English. Specifically around the comma? =AND($J$14>'Project Sold Effort'!$AI$40,$J$14<='£ Calculations (Ref Only)'!$I$4) Thanks

Hi Guys I have various lists consisting of 3 columns; some rows are coloured (only 1 colour); and others have a plain background. I'm trying to separate this data into 2 separate lists - one showing the filled data and the other showing the data with a plain background. What is the easiest way...