Add text to a cell value

[ssworthi]

I was given a file in Excel that has an ID # formatted ### but in order to use this field I would like to add the letter "V" in front of the cell so it would be V###. I have tried several ways but have not been able to. I would appreciate any help; thanks so much.

[DonkeyOte]

Do you need the V literally or for sake of aesthetics ?

If the latter you can simply apply a Custom Format of V#;;;V@ (not clear if ID is numeric or text)

If you need the value literally then simplest would be to use an adjacent cell to create the reference, eg:

Please Login or Register  to view this content.

and then copy & paste special the values in B over the originals in A.

[tlafferty]

Do you want to add the v to the actual cell contents, or just to its formatting?

A custom format of V### will cause it to display a V.

If you want to add a V to the values, use a formula in an adjacent cell:
="V"&A2

Enter above formula in B2 and B2 will display whatever's in A2 with a V in front of it.

If you'd like a macro to make the actual value change in the cell, let me know.