common data

  1. P

    Line up strings of text

    Hi, I have a list of data in sheet1. Column A contains cells which all contain text. They are capital letters apart from the right hand value which is lower case letter ("a", "b", "c", "d" or "e") e.g "TELEVISION.a", "TELEVISION.b" and so on until "TELEVISION.e". The item varies and the length...
  2. R

    Copy date from one workbook into other workbooks located in another folder, there is a common reference no. between them

    I need to pull the date from one workbook called “log” (the date is in column B) and display it in another workbook (one of which is) called “MrepoA” . I will have approx 8 workbooks in a folder called: MrepoA, MrepoB, MrepoC , etc. that need to receive date information from the “log”...
  3. D

    convert multiple colums into rows

    I would be extremely grateful if someone could look at this. How do I convert multiple rows of data in this format: Data1 data2 data3 name1 name2 name3 into data1 data2 data3 name 1 data1 data2 data3 name 2 data1 data2 data3 name 3 and so on...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top