Forumla question

[Trilback]

I want to be able to make my job easier at work. I need to be able to do the following. ex. Valeriano, Bruno D

For the above last name, first name space Middle I I need to be able to copy from a web site and it show in another cell the customer the first 6 char of there last name, first letter of there fist name + middle I. How would I do that? For the above ex the answer would be ValeriBD

 

[Sufiyan97]

it is but for some reason it's not catching the middle on my end.

Post some more samples of your data.

 

[rlv01]

I have 2016 of office at work atm for this machine.

You could try this instead.

=LEFT(SUBSTITUTE(SUBSTITUTE(TRIM(A1)," ",""),CHAR(160),""),6) & MID(SUBSTITUTE(SUBSTITUTE(TRIM(A1)," ",""),CHAR(160),""),FIND(",",SUBSTITUTE(SUBSTITUTE(TRIM(A1)," ",""),CHAR(160),""))+1,1) & RIGHT(SUBSTITUTE(SUBSTITUTE(TRIM(A1)," ",""),CHAR(160),""),1)

 

[Dave Patton]

It would help if you posted an extract of your sheet with the forum's tool named XL2BB.
You could also identify key characters. If you have hidden special characters a formula or UDF can help.

TextBefore.xlsm
	A	B	C	D	E	F	G
4	Valeriano, Bruno D	ValeriBD			44	32	66
5
1c

Cell Formulas
Range	Formula
B4	B4	=LEFT(A4,6)&MID(A4,FIND(" ",A4)+1,1)&TEXTAFTER(A4," ",2)
E4	E4	=CODE(MID(A4,10,1))
F4	F4	=CODE(MID(A4,11,1))
G4	G4	=CODE(MID(A4,12,1))