By which formula, can we get the data of few cells/rows/columns in 1 single cell/row/column? The data should not change in term of value.

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Next Question:
What will be the easiest formula for assigning Grades in Column B ?
Posted by:
Ahmed Aziz
20-March-2014

Microsoft Excel Data Center

Question ajoutée par Asheesh Kumar , Accounts & Finance Manager , Prayagraj Smart City Limited
Date de publication: 2013/05/11

Apprécier (0) Vues (14) Suiveurs (1) Réponses (4) Report Question

Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.

4 Réponses

par Ansab Khan , Sr. Officer , Meezan Bank Limited

as far as i have understand your question, you are asking to merge value into one cell, this can be done through "concatenate function" by using &.
For you want to merge a1 and b1 then your formula in c1 would be like =a1&b1 this would be appeared without space, with space formula would be like =a1&" "&b1 i hope you will find this helpful

Déprécier Réponses () Rapport

Padmavathi Duvvuri

par Padmavathi Duvvuri

Conacatenate function can be used or an ampersand(&) can be used in place of concatenation.

=Concatenate(A1," ",B1)

=A1&", "&B1

Déprécier Réponses () Rapport

par Muhammad Jawad , Senior Recruitment Analyst , SWI Inc.

If you are asking about MS Excel then you should use VLOOKUP formula to get your desired results

Déprécier Réponses () Rapport

Mike Emerson Pasaron

par Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

try using concatenate function or &

Apprécier (-1)

Déprécier Réponses () Rapport

Recherches Populaires

Offres d'Emploi Technicien Offres d'Emploi Ingénieur Offres d'Emploi Vendeur Offres d'Emploi Comptable Offres d'Emploi Informaticien

Ecrivez Votre Réponse

More Questions Like This

How to get the sum of a row along with some hidden figures in Excel?
Top Answer: Assuming the data you want to add is in A1 to A10 with A7 to A9 hidden. Just do a SUBTOTAL 9 and select r ... Voir Plus

Réponses (7)
I want to delete the "values' in cell , but not want to delete the formula behind that cell , how can i delete the value ?
Top Answer: <p>delete the source cells from where the formula is taking values.</p> Voir Plus

Réponses (4)
On a spreadsheet, how to get data from 3 columns into 1 column - eg, you have 3 columns with "1st name", "2nd name" and "Surname" - change to 1 column?
Top Answer: Hi Ruma, you have to use the formula concatenate to combine together3 columns to1. Voir Plus

Réponses (1)
For a bank to create a long-term relationship with a customer that is based on mutual long-term value creation. what is this fundamental driver?
Top Answer: <p>Agree with both answers. However intimacy by itself and good service alone may not actually prov ... Voir Plus

Réponses (6)

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?

Obtenir de l'aide