Scenario is like this col1 col2 a,b,c,d e,f,g,h output have to be like below col1 a b c d col2 e f g h how?

Asked by Last Modified  

3 Answers

Follow 0
Answer

Please enter your answer

Tutor

Hi, this can be done either using arrays or vba....as i dont go on vba unless i really think that it cannot be done using advance excel. here is the formula for you..MID($A$2,SMALL(((ROW(OFFSET($E$1,,,LEN($A$2),)))),ROW()-1),1)
Comments

Tutor

MID($A$2,SMALL(((ROW(OFFSET($E$1,,,LEN($A$2),)))),ROW()-1),1)....i put this formula in cell c2 and this a,b,c,d is written in A2 (i replaced the "," first from A2 using find and replace so now it looks like this abcd in cell A2)....Ensure that column E should be left blank as E column is used in arr...
Comments

Agile / SCRUM Consultant & Test Architect

It is a technique by which we can update a 'part' of a web page, without Re Loading the Entire Page again.(asynchronous Web applications)
Comments

View 1 more Answers

Related Questions

Excel formulas in advance level?
In excel we have lot of staff and formulas, we can learn based on your requirement, in excel vlookup, hlookup, pivot table if condition, sumif ifs, countA, if ifs, data validation, etc. and we have to...
ManojGS
How can I teach graphic designing through UrbanPro?
There are three ways to do so. Asking the student to visit your location, travelling to student's location & taking online classes. But for taking online classes, you have to make sure you and your student,...
Soma
Is it possible to learn java at home without coaching in one month?
It all depends on you. If you are already aware of programming then it is definetly possible to learn java at home. But if learn through a tutor then you can learn easily.
Pritom
0 0
5
What are the certification courses for manual testing?
ISTQB Foundation Level, Certified Software Tester (CSTE), Certified Agile Tester (CAT).
Priyanka
0 0
6

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons


Priority in TestNG
public class Priority { @Test (priority=1)public void login() {System.out.println("login");} @Testpublic void email1() {System.out.println("email1");} @Test (priority=-2)public void email2() {System.out.println("email2");} //I...
S

Sarthak C.

0 0
0


What is Cloud Computing and benefits of cloud computing ?
This is the basic introduction for the cloud computing and what are the major benefits which currently IT organization is taking from the cloud. What is cloud computing? It is the on-demand availability...

Programming Practice Technique
Any Programming Language required an Algorithm. Algorithm - It is the finite set of instructions in which each and every instruction has the meaning, instructions are not ambiguous and all the instructions...

Recommended Articles

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Looking for IT Courses ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you