formatting question

R

Raj

I was wondering if anyone knew of a way to create a custom format for
names. I use an ODBC import to obtain full names of people, and it
comes in as such: "last_name ; first_name". I can't change that order
in ODBC, thus I wind up with one column having both names, seperated by
a semi-colon. I can code a solution, I was just wondering if there was
a custom format capable of reversing the order of the text on either
side of the semicolon. Any info would be appreciated,

-Raj
 
V

VBA Noob

Hi Raj,

This should work

=TRIM(RIGHT(D17,LEN(D17)-(FIND(";",D17,1))))&"
"&LEFT(D17,FIND(";",D17,1)-1)

VBA Noo
 
Top