Extracting Letters from Text

[wbsman]

Take three Words separated by spaces. I want the first letter after the space from each word and insert into a cell.

 

[philwojo]

Here is my updated formula as well, but you've now changed from 3 words to 4, so if you keep adding it will need to be updated further.

=LEFT(A1,1)&(MID(A1,FIND(" ",A1)+1,1))&MID(A1,FIND(" ",A1,FIND(" ",A1)+1)+1,1)&MID(A1,FIND(" ",A1,FIND(" ",A1,FIND(" ",A1)+1)+1)+1,1)

 

[JoeMo]

i'm wanting DDD1 from Double Dutch Door 1

Is there a space before "Double"? If not then your request for "I want the first letter after the space from each word" is not worded correctly.

 

[wbsman]

That's because you didn't install the function correctly.

To install the UDF:
1. With your workbook active press Alt and F11 keys. This will open the VBE window.
2. In the project tree on the left of the VBE window, find your project and click on it.
3. On the VBE menu: Insert>Module
4. Copy the UDF from your browser window and paste it into the white space in the VBE window.
5. Close the VBE window and Save the workbook. If you are using Excel 2007 or a later version do a SaveAs and save it as a macro-enabled workbook (.xlsm file extension).
6. Use the UDF as you would any native Excel function.
7. Make sure you have enabled macros whenever you open the file or the code will not run.

Thank you so much, it worked.

 

[JoeMo]

Thank you so much, it worked.

You are welcome - thanks for the reply.