Help in vb excel macro
Closed
fmasse
Posts
2
Registration date
Tuesday January 26, 2010
Status
Member
Last seen
January 28, 2010
-
Jan 28, 2010 at 07:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 10:21 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 10:21 PM
Related:
- Help in vb excel macro
- Spell number in excel without macro - Guide
- Gif in excel - Guide
- Macros in excel download free - Download - Spreadsheets
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
1 response
fmasse
Posts
2
Registration date
Tuesday January 26, 2010
Status
Member
Last seen
January 28, 2010
Jan 28, 2010 at 08:35 AM
Jan 28, 2010 at 08:35 AM
dam page formating
a1 =serial number ( 77654566 )
b1 = #1 ( 32 ) c1 = #2 ( 22 )
d1 = #3 ( 12 )
e1 = empty
f1 = empty
then what i need
a1 =serial number ( 77654566 )
b1 = empty c1 = empty
d1 = empty
e1 = empty
f1 = #1-#2-#3- ( 32-22-12 )
a1 =serial number ( 77654566 )
b1 = #1 ( 32 ) c1 = #2 ( 22 )
d1 = #3 ( 12 )
e1 = empty
f1 = empty
then what i need
a1 =serial number ( 77654566 )
b1 = empty c1 = empty
d1 = empty
e1 = empty
f1 = #1-#2-#3- ( 32-22-12 )
May 12, 2010 at 10:21 PM
but in F1 you can use this formula
=B1 & "-" & C1 & "-" & D1
Drag it down to last row
select column F
Select Copy and then choose pastespecial and choose values
Then select column B, c and D and choose Clear content