Can't find the good Formule

[alexdodo]

Hello. I am new to Excel, I am learning it, but I can't do something.

So the task is like this:
I have to create 1 more collumn in right of "Comitat" named "Ecuson". In that collumn the name from "Nume participant" should be with uppercase(I guess by using function UPPER) but it should have the following format like in this photo (using a formule

Thank you a lot!

 

[jtakw]

Hi,

Like this?

Excel 2010
	A	B	C
1	John Jack Doe		JOHN JACK DOE-
2	Jane Jill-Doe		JANE JILL-DOE-
3	John Doe	Alba	JOHN DOE-Alba
4	Jane Doe	Alba	JANE DOE-Alba
Sheet4

Cell Formulas
Range	Formula
C1	=UPPER(A1)&"-"&B1

C1 formula copied down.

 

[alexdodo]

Thank you a lot man!!!

 

[jtakw]

You're welcome, welcome to the forum.

 

[alexdodo]

Hi,

Like this?

Excel 2010

	A	B	C
John Jack Doe	JOHN JACK DOE-
Jane Jill-Doe	JANE JILL-DOE-
John Doe	Alba	JOHN DOE-Alba
Jane Doe	Alba	JANE DOE-Alba

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

</tbody>

Sheet4​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C1[/TH]
[TD="align: left"]=UPPER(A1)&"-"&B1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



C1 formula copied down.

Sorry for double-post.
Can you help me with this too?

What function should I use to get the value from User collumn? Thank you a lot!

 

[jtakw]

Like this:

Excel 2010
	A	B	C	D
1	John Jack Doe		JOHN JACK DOE-	John .Jack Doe
2	Jane Jill-Doe		JANE JILL-DOE-	Jane .Jill-Doe
3	John Doe	Alba	JOHN DOE-Alba	John .Doe
4	Jane Doe	Alba	JANE DOE-Alba	Jane .Doe
Sheet6

Cell Formulas
Range	Formula
C1	=UPPER(A1)&"-"&B1
D1	=SUBSTITUTE(A1," "," .",1)

 

[alexdodo]

Thank you man. Really appreciate.
Have a good day.

 

[jtakw]

You're welcome, have a nice day.