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
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
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
Related:
- Separating numbers in a cell
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- Count if cell contains number - Excel Forum
- Cell phone battery reset code - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
1 response
roserose1
Posts
10
Registration date
Wednesday November 12, 2008
Status
Member
Last seen
May 18, 2009
Dec 19, 2008 at 02:57 AM
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
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