String concatination with space in between

[Sharmi_thangam_malat (Shar)]

.

Hello All,

I am trying to contactenate 2 strings with space in between.The formulae works in excel but throws error in UI .How to rectify this error?

Eg , First name in column 1 last name in column 2 - 3 rd coulmn Name but with space inbetween first and last name .

Thanks,
S

[Lawrance_A]

Try this String1 +" "+String2

[nadim.warsi]

why not just type “=(A2 B2)”

[Sharmi_thangam_malat (Shar)]

Hi ,

I am storing as datatable , column a, column B .How do i use your answer in that scenario ?

Thanks,
S

[Sharmi_thangam_malat (Shar)]

Hello ,

If i use your suggested solution , column c is populated with : #NAME?. I need column a +" " + column B into column C . I am using datatable .

Thanks,
S

[Madhuraj (Madhura Tendulkar)]

@Sharmi_thangam_malat

You can use following code -

User For Each Row in dt

Add assign activity inside For Each ,

row(“Column3”) = row(“Column1”).ToString+" " + row(“Column2”).ToString

Write Range the table dt in the same sheet with Add Headers Checked

Thanks,
Madhura

[Sharmi_thangam_malat (Shar)]

Hello,

Thank you ! Your solution worked .

Regards,
S

[vinay7835 (Vinay Kumar)]

Hi Madhuraj,
I’m trying to send email with mail body as per below using send outlook mail message
Dear Vinay,
Your ID 80000237 has been created In WF And password Is ab@cd
Regards
Vinay Kumar
P2P WorkFlow
Mob 1234
EBEX
But getting out put
DearVinay,
Your ID80000237has been created In WF And password Is ab@cd
Regards
Vinay Kumar
P2P WorkFlow
Mob 1234
EBEX
Used code, please support i want space after Dear and after to string.
“Dear” +row (0).ToString+“,” +Environment.NewLine+“”+Environment.NewLine+
“Your ID”+row(2).ToString+“has been created In WF And password Is ab@cd”+Environment.NewLine+“”+Environment.NewLine+“Regards”+Environment.NewLine+“Vinay Kumar”+Environment.NewLine+"P2P WorkFlow "+Environment.NewLine+“Mob 1234”+Environment.NewLine+“EBEX”

[siddu509 (Siddartha)]

@vinay7835,

Since you are hard coding the string “Dear” just provide the space after it. That would work for you. and follow the same after ID value also.
Ex: "Dear "

Sid

[vinay7835 (Vinay Kumar)]

Thanks can you tell me how can i do same activity without hard coding

[siddu509 (Siddartha)]

@vinay7835,

For not hard coded values, you can follow like how madhuraj or other mentioned above.

Sid

[vinay7835 (Vinay Kumar)]

Please help on below

[siddu509 (Siddartha)]

@vinay7835,

please check all your strings are returning values or not. you might be passing some null values so you are getting that exception.

Thanks,
Sid

[vinay7835 (Vinay Kumar)]

How can split sheet1 value in multiple sheets with value in one exl file,

Expected Result is attached
Splt1Sheets in MultipleSheets.xlsx (11.7 KB)

[vinay7835 (Vinay Kumar)]

Please help

[vinay7835 (Vinay Kumar)]

plz help