Hi, i am looking to extract the last word in an array. Sometime it will be the second word and other time the third word. Clients who have middle names i will need the third word and for clients who have no middle name i will need the second word. I need to extract the surname from the cell. pleas…

Hi @nick.v , Can you try the code below and see if it solves the requirement? :slight_smile: Trim(valueFromCell.Substring(0,valueFromCell.IndexOf("WR"))).Split(" "c).Last

HOw to extract last word in an array

Help

jcastro May 18, 2020, 12:51pm 4

Hi @nick.v,

Can you try the code below and see if it solves the requirement?

Trim(valueFromCell.Substring(0,valueFromCell.IndexOf("WR"))).Split(" "c).Last

4 Likes

Extract a text from right to left in excel

Topic		Replies	Views
Extracting surname from a cell Help activities	3	667	May 12, 2020
String Manipulation in DataTable Question Studio studio , question , activities_panel	8	179	December 16, 2023
Get surnames from a String Help	4	1493	October 28, 2019
String manipulation for name and direction Help studio , string	10	1282	February 7, 2020
Split First name Last name in excel Studio excel , activities	13	2043	May 14, 2020

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

HOw to extract last word in an array

Related Topics