Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spaces in VBA
Excel 2002, WinXP
Say that I have two cells, A1 & B1, with entries in each. I want to concatenate those two values in, say C1. But I want a number of spaces between them. That's easy to do if the number of spaces is fixed. But I have a situation where the number of spaces is a variable, say NumSpaces. How do I code the concatenation? Something like: Range("C1").Value=[A1].Value & NumSpaces??? & [B1].Value Thanks for your help. Otto |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
spaces not recognized as spaces | Excel Worksheet Functions | |||
ADD SPACES | Excel Programming | |||
A better way to get rid of spaces | Excel Programming | |||
Help copying a range with spaces to a range without spaces | Excel Programming |