comma separation

  1. D

    Sum frequency based on adjacent cell with separated by comma

    Hi Guys, I download an excel file of survey answers on a monthly basis for a report. Each line item is an unique entry. For a particular questions (multiple select): example: Which fruits do you eat: A / B / C It puts all the answers into 1 cell separated by commas. Example "A, C" or "A" or...
  2. B

    Number format

    Hi, When I enter a number like this; 3450982 and I try to break it out into millions and thousands, it is showing up like this 3450,982 instead of 3,450,982. I have tried using the custom number feature and it is still not showing up the way I want it to. Any suggestions?? Thanks.
  3. I

    Single row to be split into multiple based on a column data

    Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I would like to split a row in to multiple rows in an excel sheet.<o:p></o:p> Please refer the source data below,<o:p></o:p> <o:p> </o:p> <TABLE class=MsoNormalTable style="MARGIN-LEFT...

Some videos you may like

This Week's Hot Topics