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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I add the letter "P" to each cell of numbers on a worksheet?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating sequential numbers plus a letter 4
Showing Letters For Column Headers Rather Thann Numbers ? 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel Display certain dates 9
Can i count how many letters A from cell e10 to sell h10 ? 1
Complicated (to me!) find and replace 8
editing a cell with time 2
need to average based on criteria 2

Back
Top