Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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