Extract Last Name using TEXTAFTER function in Excel

Karunesh Gaikwad

2023-08-25 17:16:21

Why -1?

Rocky

2023-08-12 19:40:15

Hi I have bill no and Date both are joint like bill no 104/22-22/date I want remove date how I can do

Providence Williams

2023-06-27 18:30:16

Thanks alot, so helpful

Onkar Shinde

2023-06-15 20:04:09

Flash fill is quick

SACHIN SINGH

2023-06-05 07:58:01

Will it work in date and time to

R Katyayani

2023-05-05 08:09:34

How to select only for alphabets from the surname.

Arnaud Manirakiza

2023-03-31 04:44:54

Power query is another option... Transform, split columns, delimiter

mayur Khedekar

2023-03-18 12:05:21

I don't have this option in my version

PARADISE KISHTWAR

2023-03-15 13:12:49

HOW TO SEPARATE FATHERS NAME FROM A ,B,C SS/O C

Surya

2023-03-12 17:17:13

Or you can use left or right function

Nita Maurya

2023-03-11 05:33:39

Not working on 2010 excel

Nita Maurya

2023-03-11 05:31:38

What version of Excel is this

Ghurair Shaikh

2023-03-10 14:04:44

You can also use right and lens function

nivramarvin

2023-02-25 06:25:50

How about if the name is Robert De Niro, De Niro is the last name.

Karan Raj

2023-02-21 16:15:43

How to convert same formula into a shape made text, for any kind of poster making

Rajesh Khanna

2023-02-12 15:37:06

Middle name
Like

Rao kri kum giri

Ram rao Kri

Ans i

Kri kum
rao

Atul Subba

2023-02-11 08:18:19

What if we need middle name and first name

R A

2023-02-08 18:19:50

Thanks..last and first one is easy than mid

jorge herrera

2023-02-08 18:12:07

someone explain why -1?