How can I get first letter and last name together

muzzy

Active Member
Joined
Apr 8, 2014
Messages
333
If I have this? Please Help

ABC
1Last Name
First Name
What I Need
2SantiagoAnnAsantiago
3SchusterMarioMschuster
4SinghTommyTsingh
5TaylorSamStaylor

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

muzzy

Active Member
Joined
Apr 8, 2014
Messages
333
Sorry How can I do the same thing just with 4 letters go into the last name like (ASANT)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,923
Messages
5,525,653
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top