- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to merge Text/Character ?
Dear Sir
I try find the related discussion before, but it seems not easy.
I would like ask how to merge Char.A + Char.B in new column, thank you.
Char.A | Char.B | Merge |
A | 01 | A.01 |
B | 02 | B.02 |
C | 03 | C.03 |
D | 04 | D.04 |
E | 05 | E.05 |
F | 06 | F.06 |
G | 07 | G.07 |
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to merge Text/Character ?
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to merge Text/Character ?
Dear Sis
Let me describe again,
Merge1 is doable form formula (character --> concat)
Merge2 I wish to add new character (not in data table), like "_" dash. how to reach this..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to merge Text/Character ?
:Char.A || "_" || :Char.B
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to merge Text/Character ?
Thanks for quick answer