Split Full Name into Sub-Names

[tracycrown]

Dear all

Kindly help to advise how to split full name into sub-names and assign code (or number) to all sub-names.

Full Name	Name1	Name2	Code1	Code2
Johny Tan Kim Seng	Johny	Tan	72	35
Ang Soon Teng	Ang	Soon	22	63

Thank you

Tracy

[MarcoWedel]

Hi,

instead of

Code1+Code2+Code3+Code4

you can use

RangeSum(Code1,Code2,Code3,Code4)

as the RangeSum() function even returns results in cases one of its parameters is null.

hope this help

regards

Marco

[tracycrown]

Dear Mr Macro Wedel

Yes....   the answer is correct now. You are a good mentor, I have learned a new command from you today.

Thank You

Tracy