seperated

  1. K

    imported comma seperated data

    I have a sheet that i want to import data to (sheet1 B2) this data is seperated by a comma i want to seperate and create it listed in a single column on (sheet 2 B2, B3, B4 etc) can someone please help with a formula thanks in advance
  2. D

    How to merge cells into comma seperated list

    I have several cells, from F2 thru AU2. I'm trying to merge these cells into a comma seperated list in one cell. However, some of the cells are empty. Is there a way to do this?
  3. M

    IF(Column X == value or value or value or value) write Column Y to F2 seperated by comma

    Hi there, i looking for a formula or Language M code snippet or macro that does the following thing. If in column "Sort" the number is either 66 or 46 or 23 or 19 or 18 or 6 write the value of column "Count" to field "F2" but seperated by a comma. I tried some formula but didnt get the...
  4. R

    Formula to Extract text in Postal Address

    I have a cell that contains a full address e.g. Flat 10, 1 London Road, Bromley, Kent, BR1 1AA. I would like to be able to extract each of the parts of the address that are seperated by a comma. I have managed to get the first line with: =LEFT(A1,FIND(", ",A1-1) And the second with...
  5. O

    convert comma seperated words in a cell to rows (dict data)

    hello. this is a famous question but i tried a macro code that works in little rows . but i tried my dictionary data it give type missmatch error. i have two columns for word and meaning. there are 50000 rows. and some meaning cells in column B has many meaning word seperated with comma. i want...

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