combining partial data from 2 different cells

[Steven]

I am trying to combine partial data from 2 cells.
first character from one cell and last 4 character from another.

 

[Domenic]

I am trying to combine partial data from 2 cells.
first character from one cell and last 4 character from another.

Try...

=LEFT(A1,1)&RIGHT(B1,4)

Hope this helps!