What to do to fill column 2 with part of whats in column 1
 

Hi All experts,

I will try to explain what I would like to accomplish as much as I can.
If I had 2 Cells , say A1 and A2. , and A1 has this text "APPLE"

My question is how can I fill A2 with "APPLE.PDF". Is it some formula I
would need to do this?
Also if I had B1 and B2 , and B1 with "ORANGE" - How to fill B2 with
"ORANGE.PDF"

I hope I have explained what I would like to achieve.

Thank you in advance


Edwin Mashiringwani

What to do to fill column 2 with part of whats in column 1
 

On Sat, 19 Nov 2005 01:00:29 +0000 (UTC), "Edwin Mashiringwani"
wrote:

Hi All experts,

I will try to explain what I would like to accomplish as much as I can.
If I had 2 Cells , say A1 and A2. , and A1 has this text "APPLE"

My question is how can I fill A2 with "APPLE.PDF". Is it some formula I
would need to do this?
Also if I had B1 and B2 , and B1 with "ORANGE" - How to fill B2 with
"ORANGE.PDF"

I hope I have explained what I would like to achieve.

Thank you in advance


Edwin Mashiringwani



In A2: =A1 & ".PDF"
B2: =B1 & ".PDF"



--ron

What to do to fill column 2 with part of whats in column 1
 

"Ron Rosenfeld" wrote in message
...

Hi All experts,

I will try to explain what I would like to accomplish as much as I can.
If I had 2 Cells , say A1 and A2. , and A1 has this text "APPLE"

My question is how can I fill A2 with "APPLE.PDF". Is it some formula I
would need to do this?
Also if I had B1 and B2 , and B1 with "ORANGE" - How to fill B2 with
"ORANGE.PDF"

I hope I have explained what I would like to achieve.

Thank you in advance


Edwin Mashiringwani



In A2: =A1 & ".PDF"
B2: =B1 & ".PDF"



--ron


Thanks very much for this . it resolved my problem.