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

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.

In article <Dno.26zczb_1146237601.3437@excelforum-nospam.com>,
Dno <Dno.26zczb_1146237601.3437@excelforum-nospam.com> wrote:

> 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

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-AA2088.09305728042006@msnews.microsoft.com...
> 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.
>
> In article <Dno.26zczb_1146237601.3437@excelforum-nospam.com>,
> Dno <Dno.26zczb_1146237601.3437@excelforum-nospam.com> wrote:
>
>> 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

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

Peter

Hey Thanks alot 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.


Dno wrote:
> 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
>
>
> --
> Dno
> ------------------------------------------------------------------------
> Dno's Profile: http://www.excelforum.com/member.php...o&userid=33947
> View this thread: http://www.excelforum.com/showthread...hreadid=537242

Works better if you use P0 as custom formatting mask.

"JAMES T." <sylvester1501@peoplepc.com> escreveu na mensagem
news:1146246158.642467.295300@e56g2000cwe.googlegroups.com...
> 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.
>
>
> Dno wrote:
>> 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
>>
>>
>> --
>> Dno
>> ------------------------------------------------------------------------
>> Dno's Profile:
>> http://www.excelforum.com/member.php...o&userid=33947
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=537242
>