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
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)))
Gives me an 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:
and this, this is SplitName:
When i run the program it showes this:
And i want it to show like this:
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:
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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.