=right(A2;len(a2)-find(" ";a2))
madofako 1 month ago
=left(A2;find(" ";A2)-1)
Thanks for this
drdomski 4 months ago
Thank you for the video :-)
avner2sss 4 months ago
This has been flagged as spam show
I like CONCATENATE() or & more than this since it won't give me #VALUE! in case I don't have a last name (and I don't need to use extra space or ? as a second name) calcfunctions * blogspot * com/2008/07/concatenate-or.html
Thanks, this video helped me accomplish my task.
hottraffic19 4 months ago
Thanks.
urinine 4 months ago
Glad it helped.
sc092270 3 years ago
=right(A2;len(a2)-find(" ";a2))
madofako 1 month ago
=left(A2;find(" ";A2)-1)
madofako 1 month ago
Thanks for this
drdomski 4 months ago
Thank you for the video :-)
avner2sss 4 months ago
This has been flagged as spam show
I like CONCATENATE() or & more than this since it won't give me #VALUE! in case I don't have a last name (and I don't need to use extra space or ? as a second name) calcfunctions * blogspot * com/2008/07/concatenate-or.html
avner2sss 4 months ago
Thanks, this video helped me accomplish my task.
hottraffic19 4 months ago
Thanks.
urinine 4 months ago
Glad it helped.
sc092270 3 years ago