Flash formula or Alpha numeric Text split

Question

Hi,

         I need to split numbers from one cell to two column,  Example: A1 cell contain Alpha numeric word like 34xxxX2.0, A2 cell have CDEFX56xxX1.0, A3 cell have 10.50GhjkX0.60,

A4 cell have Xccvz13.75X8.50. A5 have 100X250rhjjjkX3.0, A6 cell have 56X56dsfX1.6

Flash fill doing effectively. But flash sometimes not work decimal split when row have 500 more. I cannot find and not adjust fraction.

My result would be B1 cell have  34 and C1 cell have 2.0, B2 cell have 56 and C2 cell have 1.0 and B3 cell have 10.50 and C3 cell have 0.60 and B4 cell have 13.75 and C4 cell have 8.50,B5 cell have 100 and C5 cell have 3.0, B6 cell have 56 and C7 cell have 1.6

Answer 1

Hi,

Flash Fill works just fine for me.  In cell B2:B3, type '2.0 and '1.0.  Select B2:B7 and go to Data > Flash Fill.

Hope this helps.

I have 500 rows More with More Decimal fraction, I cannot find flash fill creating Mistakes.

Flash Fill works fine but More times Decimal fraction not work.

Answer 2

Hi Ashish Mathur,

            Yesterday, Two before asked new excel questions. Product categories group to product name wise Godown cum with value.

I try power query. I have lack of various steps that is insufficient knowledge to solve my problems. I searched in community. Most of Problem you solved using Power query. already I asked help in Community expert. I am awaiting for your solution also.

Answer 3

Hi,

Share the link of that post.

Answer 4

Hi Ashish

This link below

https://answers.microsoft.com/en-us/msoffice/forum/all/excel-power-query-or-vba-code-solutions-required/ff0a76bc-09b2-46d5-983c-fb0a4cd7ec3e