Hello,
I should union in a single cell in a text that is 3 cells
in A2 = ABCDE001 list employees
in B2 = name
in C2 = commun
union = list employess name commun
A Thanks in advance.
max_max
--------------------------------------------------------------------------------------
Ciao,
dovrei unire in unica cella un testo che è in 3 celle
in A2 = ABCDE001 list employees
in B2 = name
in C2 = commun
unione = list employess name commun
Una grazie anticipato.
max_max
If I understand correctly use the concatenate function.
= A2 & B2 & C2
or =concatenate(A2,B2,C2)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello alansidman,
thanks but the answer is not accurate.
The text is in A2 = <ABCDE001 list employees> have to copy only the part:
<List employees> without <ABCDE001>. -
I hope I explained.
max_max
------------------------------------------------------------------------------
Ciao alansidman,
grazie della risposta ma non è esatto.
Il testo che è in A2 = < ABCDE001 list employees > bisogna copiare solo la parte:
< list employees > senza < ABCDE001 >.-
Spero di essermi spiegato.
max_max
Is this part of the cell (ABCDE001) always have the same number of characters. In your example 8. Or does it vary?
Are always 8 characters.
max_max
To get the value from A2; =right(A2, Len(A2)-8)
You can then concatenate that with Cells B2 and C2 as described earlier.
Alan
Thanks alansidman,
is perfect!
The Italian translation of the formula:
=DESTRA(A2;LUNGHEZZA(A2)-8)&" "&B2&C2
max_max
---------------------------------------
Grazie alansidman,
è perfetto!
La traduzione della formula in italiano:
=DESTRA(A2;LUNGHEZZA(A2)-8)&" "&B2&C2
max_max
molto buono Max_max for the translation. I'll add it to my Italian.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks