Hi Pascal,
Your understanding is exactly correct, Kindly help to us.
Thanks & Regards,
Ganesh
>
> On Sat, Nov 24, 2012 at 4:24 AM, bpascal123 wrote:
>
>> Merge1.txt = consist of 1.txt, 2.txt and 3.txt also the same order (1, 2
>> & 3) to copy paste in Merge1.txt file.
>>
>> consist of the con
HI,
As per your formula if you have 50 Rows you need 50 Index to do the same.
Good effort but it can be more better.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of >>Excel Beginner<<
Sent: 23 No
Hi Rajan,
I have question here..
Just wanted to know..what is the use of ROW(A1) A2 a3..etc etcc...
HERE..
=IFERROR(IFERROR(INDEX($C$2:$J$2,0,ROW(A1)),INDEX($C$3:$J$3,0,ROW(A1)-COUNTA($C$2:$J$2))),INDEX($C$4:$J$4,0,ROW(A1)-COUNTA($C$2:$J$3)))
On Fri, Nov 23, 2012 at 11:53 PM, >>Excel Begin
Merge1.txt = consist of 1.txt, 2.txt and 3.txt also the same order (1, 2 &
3) to copy paste in Merge1.txt file.
consist of the content of 1.txt, 2.txt ... not just what's on the
spreadsheet.
Tell each step of the macro i.e:
1. Open or create a file from path "C:\Merge\Merge1.txt" for the first
Hi Rajan Sir,
please find the attachment.
*Regards,*
*
*
*Excel Beginner*
*
*
On Fri, Nov 23, 2012 at 10:51 PM, Rajan_Verma wrote:
> * *
>
> *Hi Group,*
>
> *
> here is a formula Practice , hope you will enjoy this,*
>
> * *
>
> *Suppose you have data like this below table, y
Hi Group,
here is a formula Practice , hope you will enjoy this,
Suppose you have data like this below table, you need create a formula to
make it in a series like 2nd table
375
814
582
509
349
395
642
302
180
884
922
941
474
170
584
370
665
329
245
981
547
650
Dear Experts,
Thank you very much to all …. I'm eager to learn many thing on Excel
I need assists from all Experts . I want to build my career in this profession
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Bé Tr?n Van
Sent: 23 Novemb
You check your data, a number of Cell contains a space in front data leeu.
To remove white space you use the TRIM function to, at J3 you use the
formula:
= TRIM (C3)
Complete copy of the column J, dragon to column E you choose Paste Special
Value, and click the OK button.
2012/11/23 Manjunath Na
