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