Separating numbers in a cell

Closed

hotbox - Dec 19, 2008 at 01:23 AM
roserose1 Posts 10 Registration date Wednesday November 12, 2008 Status Member Last seen May 18, 2009 - Dec 19, 2008 at 02:57 AM

Hello,
I want to know how to use macro in my report,
in sheet 2 cell a2 b2
63 45,76,22,48

how can i come up an output that when i click sheet 1 the output must look like this:

a2 b2
63 45
63 76
63 22
63 48

Separating numbers in a cell
If cell contains date then return value ✓ - Office Software Forum
Count if cell contains number - Excel Forum
Cell phone battery reset code - Guide
Conditional formatting if cell contains text - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum

1 response

Answer 1 / 1

roserose1 Posts 10 Registration date Wednesday November 12, 2008 Status Member Last seen May 18, 2009
Dec 19, 2008 at 02:57 AM

hi
this is a link where you can learn more about how to use macros in your works:
http://office.microsoft.com/en-us/excel/HA011189581033.aspx

Similar discussions

help me to add particular cells

If a cell contains any text then add a value

If cell A1 has text then cell B2 has today's Date

Fill adjacent cell with number from text answer

Excel function question

Similar discussions

Subscribe To Our Newsletter!