mistawicket
New Member
- Joined
- Jun 16, 2008
- Messages
- 25
If I have a table that has a person's 1st name in A1, 2nd name in A2 & a number in A3, how can I have Excel take the first letter of A1, the whole last name from A2 & the number in a 3 to paste in 1 cell
A1 A2 A3
for example John Smith 1
would create an ID: JSmith1
I'd like a formula to calculate this, but I don't really know where to begin here...
A1 A2 A3
for example John Smith 1
would create an ID: JSmith1
I'd like a formula to calculate this, but I don't really know where to begin here...