Excel: How do I take the first character of 3 different cells and last 4 numbers of 1 cell and combi
Posted
by terry
on Stack Overflow
See other posts from Stack Overflow
or by terry
Published on 2010-05-31T15:10:13Z
Indexed on
2010/05/31
15:12 UTC
Read the original article
Hit count: 304
Filed under:
Microsoft
|excel-formula
if a1 is bob, b1 is james, c1 is ricky, and d1 is a ssn#(123-45-6789), how do i combine the first charactersos a1, b1, and c1 and the last four of the ssn so that it says bjr6789?
© Stack Overflow or respective owner
