In article ,
Steven wrote:

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!