Excel - Write Cell Assitance

[Tschultz (Tamara)]

Hello,

I am using the activity Write Cell, however I’m having trouble getting the excel formula Proper to work. Here is a screen shot of my activity.

However when completing the action it’s grabbing the name and not the cell number.

Which is causing the error below:

Any thoughts on how I fix this? Thanks,

[Aashik_Sweekrith]

Hi @Tschultz

The first column value must be passed within the quotes since you are not passing the cell number for Proper function.

Try giving “=PROPER(”“”+CurrentRow.ByField(“Embossed Name”)+“”“)” in What to write

Hope this helps!

[Yoichi]

Hi,

Can you try to use ModifyText in advance, as the following?

Regards,

[Tschultz (Tamara)]

I tried what you had above but it didn’t work so I just played around with it and had success!

Thanks!