Remove last characters in excel

Thanks!
Can i do the same just with another column “name”. here i want to split the column in 2. with write cell?
still got a space in front of the first name

if the name was “ Peter Bech Holm Hesmo”

first column: Peter
second: Bech Holm Hesmo

Hi,

Use the below formula it will do the trick. thanks.

=TRIM(RIGHT(A2,LEN(A2)-FIND(" ",A2)))

1 Like

Gives me an error
error

“=TRIM(RIGHT(A2,LEN(A2)-FIND(” “,A2)))”

It doesn’t move all names, after the first name, to a new column, only trim the column to a knew one?

You have to build some thing like below to build the logic in uipath. sorry i dont understand your last question. the formula which i shared working i have tried with the names you mentioned it is retrieving all the name after first space. thanks.

“=TRIM(RIGHT(A2,LEN(A2)”+Hiphen+“FIND(”+CHR(34).toString+CHR(32).toString+CHR(34).toString+“,A2)))”

Sorry i wil try to explain it better.

im doing this:
Split1
and this, this is SplitName:

When i run the program it showes this:
split3

And i want it to show like this:
Split4

Hi,

Please try like below. it is working fine for me. refer the attached work flow. thanks.

ExcelFormulaDemo.zip (9.4 KB)

Sorry but it doesn’t work for me.
Do you have another good idé, of how i can do this?

Probles is, that in the “name” column i only want the first name, not the full name.

Like this:
Split4

Hi,

Refer the updated work flow and see it Suits your requirement. Sorry if i am not helping much in this issue. thanks.

ExcelFormulaDemoUpdated.zip (9.5 KB)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.