How Do I Add The Letter P in Front Of Each Number in a Seriers of Rows in one collum?

  • Thread starter Thread starter Dno
  • Start date Start date
D

Dno

Hi,

I have a collum with different numbers in each row.

Example:

23
34
56
67
44

I'd like to add the letter P before each number all at once rather then
typing
P before each one manually.

Example:
P23
P34
P56
P67
P44

Was wondering to go about doing this?

Thanks

Dino
 
One way:

Enter in an unused column (say, column B):

B1: ="P"&A1

Copy column B. Select Column A. Choose Edit/Paste Special/Values.
Clear/Delete column B.
 
JE McGimpsey said:
One way:

Enter in an unused column (say, column B):

B1: ="P"&A1

Copy column B. Select Column A. Choose Edit/Paste Special/Values.
Clear/Delete column B.
Click to expand...

But be aware that they will then be treated as text, so no calculations with
them!

Peter
 
An easy way to do this is to use custom formatting. P#### this format
will place a P in front of any number in the cells.
 
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

How to type each letter of the alphabet automatically in a specific color in Word? 0
How to add a letter in front of number and behind a number 5
count a pair of numbers in row in a table 1
Making one cell in another row equal another all the time 4
Need help adding a front slash "/" in between numbers that do nothave it. Examples included. 12
I have a column of numbers and I need to put the letter "P" in fr. 2
I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS 5
adding to certain characters/numbers in multiple rows in certain a 3

Back
Top