| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with a specific number of spaces
Works like a charm, thanks Tim
"tim m" wrote: This should work though I'm not sure if it is the most efficient way. Create a new column in the column enter this formula =A1&" "&B2&" "&C3&" "&D4 (Put the proper number of blanks spaces inbetween the " ") That should give you the result you seek, then copy the formula down. NOTE: this will only work if the rest of your data follows your first example, as in the next data is A2,B3,C4,D5 etc. "Derek M" wrote: Hi all I would like to do this in excel and wonder if its possible In cell a1 i have 1234 in b2 i have an address in c3 i have 600.00 and in d4 i have 1 I have to have them concatenated but also i need 5 spaces after the first cell, 4 spaces after the second and 6 spaces after the third when concatenated (hope this makes sense) So it would look like this in a1 eventually: 1234 47 Beufort drive 600.00 1 Hope someone might be abke to help as i have 685 lines of this to do :) Thanks in advance Derek |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format to a specific number of spaces | Excel Discussion (Misc queries) | |||
| Concatenate Text... with spaces | Excel Worksheet Functions | |||
| Add spaces for specific fields to paste in | Excel Discussion (Misc queries) | |||
| CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH | Excel Worksheet Functions | |||
| Replacing specific characters with spaces | Excel Worksheet Functions | |||
![Derek M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
