Skip to main content

Advance Excel || 6) Concatenate Function in MS Excel

  




Advance Excel || 6) Concatenate Function in MS Excel

Example-1

Title

First Name

Middle Name

Last Name

Full Name

Dr.

John

A.

Jacob

?

Mr.

Nathan

F.

James

?

Mr.

Adrian

B.

Anderson

?

Mr.

Gerard

G.

Jacob

?

Dr.

Zacharias

C.

Charlie

?

Dr.

Arne

H.

Thomas

?

Mr.

Fexlix

D.

William

?

Mr.

Isaac

I.

Noah

?

Mr.

Kane

E.

Ethan

?

Dr.

Joshua

J.

Joseph

?


Example-2

Text1

Text2

Formula

Black

White

?

Tea

Coffee

?

Month

25-12-2020

?

James

Thomas

?












.

Comments

Popular posts from this blog

SAP MM (Materials Management)

  SAP Materials Management (SAP MM)- Organizational structure/ Company structure What is a MM? Materials management is  the process of planning and controlling material flows . It includes planning and procuring materials, supplier evaluation and selection, purchasing, expenditure, shipping, receipt processes for materials (including quality control), warehousing and inventory, and materials distribution. Ø    How to Start SAP server? /POWER ON (Ctrl +B) Ø    How to POWER OFF (Ctrl + E) SAP Server? Ø    How to Suspend SAP Server? (Ctrl + J) ü    ECC 6.0 Latest version of SAP server ü    ECC (Enterprise Central Components) ü    SPRO (SAP Project Reference Object) ü    IMG (Implementation Guide) ü    Ctrl + Alt + Enter (Full Screen) ü    Going back to SAP EASY ACCESS screen . /N (forward slash & N) in command window . Transactions Code (T- code) Go to Additional Information -> Additi...

SAP-FICO with GST (Goods & Service Tax), TDS (Tax Deducted at Source) Index /Syllabus / System Application Programming & Data Processing (Finance & Controlling)

   SAP (FICO) FINANCE & CONTROLLING System Application Programming & Data Processing BASIC SETTING OF FICO CHAPTER NO   PARTICULAR T-CODE 1   Define company OX15 2   Define company code (HO) OX02 3   Assign company code to company OX16 4   Define business area OX03 5   Define chart of account OB13 6   Assign company code to chart of accounts OB62 7   Define accounts group with Number range OBD4 8   Define retain earning account OB53 9   Assign...

TallyPrime Volume-2 (Purchase & Sales voucher, Bank Payment, Bank Receipt, Cost Centers, Interest Calculations, Use separate Actual & Billed Qty columns in invoice, IGST, Multiple Pric, sales Voucher class, IGST, Multiple Price Level)

  How to Enable GST in TallyPrime ? Press F11 Features -> Taxation (Enable Goods & Service Tax (GST) -> Yes