Fields - Columns

Hi,

I have about 50 Fields. I am trying to create 25 out of 50 fields into one
fields so that I like to see 26 fields instead of 50 fields.

Your help would be much appreciated.

Thanks

Not quite clear as to your requirements but do you need a delimiter for
the 25 fields that you want to combine?

Presuming you do, try this (using "|" as the delimiter between fields)
:-


=concatenate(a1,"|",b1,"|" etc.)


Is that what you were after?


Best regards



Deepak Agarwal


---
Message posted from http://www.ExcelForum.com/

Thanks for reply that I'm really appreciated. No , I am looking for each row from each fields.

example:

A1 as a new column

1st Row from Field 26

2nd Row from Field 27

so on...

Thanks again......



************************************************** *****************************

"agarwaldvk " wrote in message ...

Not quite clear as to your requirements but do you need a delimiter

for the 25 fields that you want to combine?



Presuming you do, try this (using "|" as the delimiter between fields)

:-

=concatenate(a1,"|",b1,"|" etc.)

Is that what you were after?

Best regards

Deepak Agarwal

---

Message posted from http://www.ExcelForum.com/

Where do these "fields" exist?
"Bill" wrote in message ers.com...
Thanks for reply that I'm really appreciated. No , I am looking for each row from each fields.

example:

A1 as a new column

1st Row from Field 26

2nd Row from Field 27

so on...

Thanks again......



************************************************** *****************************

"agarwaldvk " wrote in message ...

Not quite clear as to your requirements but do you need a delimiter

for the 25 fields that you want to combine?



Presuming you do, try this (using "|" as the delimiter between fields)

:-

=concatenate(a1,"|",b1,"|" etc.)

Is that what you were after?

Best regards

Deepak Agarwal

---

Message posted from http://www.ExcelForum.com/