I use VLOOKUP to bring a person's name from a database into a form. In the database the name always has the format of christian name(s) followed by surname. There can be 1, or 2, or however many christian names.
The form requires that I enter surname in one cell and christian name(s) in a separate cell so I need to split the name.
The problem that I'm having, when I try the various methods that have previously been posted for splitting names, is that the underlying VLOOKUP formula gets split, not the visible output from the formula.
How do I resolve this so that the visible name gets split, not the underlying formula? At the moment I'm bringing the full name into cell AJ3; the surname has to be put into cell F37 and the christian name(s) into S37. If it helps, there's plenty of spare real estate to the right of the form, so if a helper cell is needed for temporary data, any cell (other than AJ3) to the right of col AH and between rows 1 to 50, is available. I'll assign the coding to a "Split Names" button on the worksheet.
The form requires that I enter surname in one cell and christian name(s) in a separate cell so I need to split the name.
The problem that I'm having, when I try the various methods that have previously been posted for splitting names, is that the underlying VLOOKUP formula gets split, not the visible output from the formula.
How do I resolve this so that the visible name gets split, not the underlying formula? At the moment I'm bringing the full name into cell AJ3; the surname has to be put into cell F37 and the christian name(s) into S37. If it helps, there's plenty of spare real estate to the right of the form, so if a helper cell is needed for temporary data, any cell (other than AJ3) to the right of col AH and between rows 1 to 50, is available. I'll assign the coding to a "Split Names" button on the worksheet.
