Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Text to Column 2
- Thread starter hewissa
- Start date
-
1
- #2
A = Last name
B = First name
C = Middle name
=B1&" "&C1&" "&A1
A = First name
B = Middle name
C = Last name
=A1&" "&B1&" "&C1
Anne Troy
Way cool stuff:
B = First name
C = Middle name
=B1&" "&C1&" "&A1
A = First name
B = Middle name
C = Last name
=A1&" "&B1&" "&C1
Anne Troy
Way cool stuff:
-
1
- #3
Assuming First, Middle, Last in columns A,B,C then you can get the full name with this:
[blue]
[/color]
However, if not every name has a middle initial, you would need to use something like this:
[blue]
[/color]
[blue]
Code:
=A2&" " &B2&". "&C2However, if not every name has a middle initial, you would need to use something like this:
[blue]
Code:
=IF(B2="",A2&" "&C2,A2&" "&B2&". "&C2)- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question