Help with name format Please 1

[jp3333]

I a writing a Crystal Report where I have a LAST NAME field and a FIRST NAME field. I need to have it show on the report as last name first initial, like
SMITH J with just one space between the last name and the initial. This seems like it should be easy but I just can't figure out how to do it.

Thanks!

 

[synapsevampire]

Try:

trim({table.last}) & " " & left(trim({table.first}),1)

-k

 

[jp3333]

That worked...thanks so much!