Splitting in different cells

Iron Contributor

Hello Everyone,

Wish you a HAPPY NEW YEAR.

 

I have this data :

Screenshot (5850).png

 

The result should come like this :

Screenshot (5851).png

 

So, what formula should i write ?

 

I am using Microsoft Office 2016

 

Please help..

 

Here is a attached file..

 

2 Replies

@Excel 

Many roads lead to Rome and even more to a solution in Excel :).

...you can use

=MID(A2;2;3)  you can insert this formula in E2 and just pull it down with the mouse

or

=LEFT(A2; SEARCH(" ";A2;1)) you can insert this formula in D2 and just pull it down with the mouse.

See the file.

 

Hope I was able to help you with this info.

 

 

Nikolino

I know I don't know anything (Socrates)

 

@Excel 

This can be done with flashfill.

Enter manually "A", "A" in cells B2:B3 and then press ctrl+E.

Then enter manually "BC", "BC" in cells C2:C3 and then press ctrl+E.

 

This returns the result shown in attached file. If you want entries in 

cells C10:C14 just enter manually "DEC" in cell C10 and press ctrl+E.

I work with Excel 2013.