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

  • Thread starter Edwin Mashiringwani
  • Start date
E

Edwin Mashiringwani

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
 
R

Ron Rosenfeld

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
Click to expand...

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



--ron
 

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

creating an XLS file from " files" data in a Folder 2
Extracting data from one Worsheet to Another Worksheet with common link value 1
How to choose maximum value 7
how to have cells automatically fill when entering value in ref 2
Find a value in table 2
How do I incorporate 2 columns into 1 column 3
Cell Data by Column 3
Excel Add 60 days to column 1 or column 2 based on whether column 2 has data 1

Top