How to Calculate Cell with Name In It

[paulepage14]

Hi, How would i calculate a cell with a name in it? What i would like to do is make the Cell with the name in it equal "Name" + the number in the corresponding cell, i have attached an Excel File to show what i am looking for. Thanks

[63falcondude]

How does Excel know which Robert to look at? There are two of them in column S.

[paulepage14]

Sorry i always use the last name also, So Robert would have a last name normally. Thanks

[63falcondude]

Are the employee names in column A manually typed in or are they the result of a formula?

If they are the result of a formula, we can put that result along with the corresponding number in the same cell.
If they are manually entered, you will have to do something else such as putting the corresponding number in another cell as you cannot have both a formula and a hard-coded value in the same cell.

Assuming that the names are manually entered, I would unmerge columns A and B, have the names in A and the number in B.
If that sounds acceptable, I'll whip that up and show you how it would look and what formula would get you there.

[paulepage14]

Ya sure we can absolutely try that. Thanks

[63falcondude]

B2 =IFERROR(INDEX(U:U,MATCH(A2,S:S,0)),"")

Delete the trailing spaces after the name in S2.

See attachment.

[FlameRetired]

Another observation.

There are trailing spaces in some of your data. Where there is one there are likely others. See S2 as well as column A. These need to be cleaned up ... standardized.

[paulepage14]

Thank you, That's perfect!!

[63falcondude]

You're welcome. Glad we could help.

Thank you for the rep and for marking this thread as SOLVED!