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 |
|
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.
CAclubindia
