Hi everyone

I've tried this on a VBA and it worked on the first time but right now it just keep getting errors. So i dont want Macro anymore.
I wonder if you could help me create a formula that gets two names, and returns the first letter of the first name, + the first and last letter of the second name. All together as an abbreviation.
Like this:
New York= NYK


Thanks in Advance