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

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
 
J

JE McGimpsey

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.
 
P

Peter Andrews

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
 
J

JAMES T.

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.
 
Top