Jan 01 2022 10:16 AM - edited Jan 01 2022 10:17 AM
Hello Everyone,
Wish you a HAPPY NEW YEAR.
I have this data :
The result should come like this :
So, what formula should i write ?
I am using Microsoft Office 2016
Please help..
Here is a attached file..
Jan 01 2022 10:59 AM
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.
I know I don't know anything (Socrates)
Jan 01 2022 11:28 AM
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.