Excel

Dear Sir

The yellow paste information should come in A column.

Is ther any formule to do this 

    INDUS TOWERS LTD                
17-Dec-2014 BQTS466   20555.00 Dr 20555.00 Dr       20555.00 Dr   31-Mar-2017
      20555.00 Dr 20555.00 Dr       20555.00 Dr    
    Information Publicity Press Meet                
22-Feb-2014 AST6546   1853.00 Dr 1853.00 Dr       1853.00 Dr   22-Feb-2014
      1853.00 Dr 1853.00 Dr       1853.00 Dr    
    Integra Software Services (P)Ltd              

 

 

Replies (7)

Equation  = yellow colour cell

Then drag this equation 

You can see "Text to Columns" Function in Excel. If it does not work, then upload excel file so that I can find a way out.

You can Use "Text to Columns" Function in Excel. If it does not work, then upload excel file so that I can find a way out.

You can Use "Text to Columns" Function in Excel. If it does not work, then upload excel file so that I can find a way out.

You can Use "Text to Columns" Function in Excel. If it does not work, then upload excel file so that I can find a way out.

You can Use "Text to Columns" Function

Other then formula approch.

 

Hopy yallow cells are in C Column and except yallow cells no other text are theire in other cells.

Select C colum at top.

 

Press Ctrl-X.

Goto  A1

Right Click & select Insert Cut Cells from the options.




 

 

 

 

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details