I have a column of numbers and I need to put the letter "P" in fr.

[Lettie]

How do I add the letter "P" to each cell of numbers on a worksheet?

 

[Dave F]

=CONCATENATE(A1,"P")

Dave

 

[Ron de Bruin]

Hi Letty

You can try this macro for column A

Sub test()
Dim cell As Range
On Error Resume Next
For Each cell In Columns("A").SpecialCells(xlCellTypeConstants, xlNumbers)
cell.Value = "P" & cell.Value
Next cell
End Sub