Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Say column B in an Excel sheet contains ForeNames and column C contains FamilyNames, how would I merge these two together in an inserted Column D as <forename<space<familyname? Also another column contains numeric values with 3 or 4 digits. I need to pad these numbers with a leading zeros making 234 to 0234 and also convert this field to a string field to make sure that excel doesn't strip this zero off again. How would I do this..? Thanks a lot if someone has a couple of code snippets which can give me a point of departure with routines like this in the future regards tor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If-Else Simple Loop function | Excel Programming | |||
Simple question on For...Next loop | Excel Programming | |||
Some help w/ simple loop, please? | Excel Programming | |||
simple loop macro | Excel Programming | |||
simple loop macro | Excel Programming |