Is it possible to Flash Fill Series without formatting?

Is it possible to Flash Fill Series without formatting? Please don't suggest using the Fill Without Formatting option, because that doesn't seem to work when Filling a Series. Unless of course, you know how to make it work using it with the Series option.

If all else, I can deal with most of the formatting, but the Borders must go.

Thanks
Mike

Originally Posted by oeldere

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

The question doesn't just apply to my current worksheet but for any Excel worksheet. It's more or less just a general question of whether it can be done or not.

I would just like to know if it is possible to Flash Fill a Series of numbers without formatting? Because currently, when you Flash Fill a Series in Excel 2013, the first cell's formatting it carried over to all the Flash Filled cells. So, if the first cell had a border, now all of the Flash Filled cells have a border, but at least the numbers are sequenced correctly now. If you choose Flash Fill Without Formatting, then you don't get a series of numbers, but instead, the same number copied multiple times. The formatting isn't copied, so that good, but now you don't have the sequence of numbers you want.

Mike

Modify,

Excel defaults to fill series, so doing the without formatting should work, as long as excel can tell it's a series. If you drag just {1}, it'll stay just {1}, but if you set up {1,2,3} and drag that, it'll continue {4,5,6}, do that Without Formatting and you're there.

My problem is actually the opposite. I have a cell with some weird text followed by 10, such as "CS14+(30N14)+N10", and when I drag this without formatting is makes it go to "CS14+(30N14)+N11" etc (note the N10 vs N11). I want the fill without formatting, without it auto-making this a series.

And actually, to answer my own question, I just need to set up {1,1} and drag that without formatting, just like all you need to do is set up {1,2,3}.

PS: By {a,b,c} I mean that a stack of three consecutive cells that you can highlight and drag.