Re: ]] XL-mania [[ copy paste special with transpos add |

 

Dear Endar,

Dengan bantuan makro,

Function gabung(Area As Range, Optional TandaPisah As String = "") As String
'anton suryadi 5/Jun/2010
For Each a In Area
    b = b & a.Text & TandaPisah
Next
gabung = Left(b, Len(b) - 1)
End Function

File terlampir


>semoga bermanfaat

---

From: "WATI, ENDAR (ENDAR)** CTR **" <Endar.Wati@alcatel-lucent.com>
To: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Sent: Fri, June 4, 2010 2:41:15 PM
Subject: ]] XL-mania [[ copy paste special with transpos add |

 

Dear Pakar Xl

 

Bisa minta tolong ada yang bisa kasih solusi saya punya data di exsel 6 baris,

Saya ingin gabung dalam satu baris tapi disetiap Part Number tersebut dikasih tanda pemisah seperti ini |.

Bisa t ida k yah? Karna selama ini saya kerja secara manual di copy di notepad dulu or di word baru di copy lagi ke exsel.

 

Makasih semua atas bantuannya

 

1AB095530023

1AB128500002

1AC001100022

3CC13423AAAA

3CC50074ABXX

3CC58019AAXX

Menjadi :

1AB095530023| 1AB128500002|1AC001100 022|3CC13423AAAA |3CC50074ABXX| 3CC58019AAXX

 

Regards,

Endarwati

 

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 86

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| momod akan terdampar seminggu lagi, moderasi akan lemodmod...     |
| hidup tanpa google dan fesbuk dan yahuuuu... ampun dehhh...       |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

---

Get real-time World Cup coverage on the Yahoo! Toolbar. Download now to win a signed team jersey!

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___