Full Name field with appropriate spaces - how?

[lissachelle]

I apologize if this is a repeat question, but I searched at length and couldn't find my answer. I've been trying to figure this out for years without luck.

I would like to make a "full name" field utilizing mergefields that comes out clean. How can I ask it to look at one field and if that field is not empty, to insert a space? For example, <<If <<MiddleInitial>> <> "" " " "">> or if the field MiddleInitial is not empty, insert space. I've tried using separate "spacer" fields but couldn't figure out if it would work with a calculation. Is there a way to do this?

Thanks in advance!

[-Queue-]

Why not just a calculation to create the full name and insert it as the merge field?

TrimAll( NameFirst & " " & MiddleInitial & " " & NameLast; 0; 0 )

[lissachelle]

I'll try that, thanks.

[LaRetta]

JT! This eliminates the need to test the field(s) for text to determine whether to include a space. I will be changing several IsEmpty() Case statements in one-line addresses and such.

God, 7 rocks! I like this very much, thank you!