Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help concatenating and formulas
I'm trying to concatenate 2 columns "project name" and "project number".
This is what I would like to do with the following given: concatenate column width: 32 Project name: Microsoft Project number: 121212 formula: = '=concatenate(A1," ",A2) current output = Microsoft 121212 (17 characters) attempting output = Microsoft 121212 (32 characters) basically i want to add spaces between the two based on the width of the column minus the number of characters of the current output (note that each row will have a different number of characters. In other terms, i want to push "microsoft" to the far left of the cell and "121212" to the far right Can this be done? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help concatenating and formulas
How about
=A1&REPT(" ",32-LEN(A1&B1))&B1 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Arkitek" wrote in message ... I'm trying to concatenate 2 columns "project name" and "project number". This is what I would like to do with the following given: concatenate column width: 32 Project name: Microsoft Project number: 121212 formula: = '=concatenate(A1," ",A2) current output = Microsoft 121212 (17 characters) attempting output = Microsoft 121212 (32 characters) basically i want to add spaces between the two based on the width of the column minus the number of characters of the current output (note that each row will have a different number of characters. In other terms, i want to push "microsoft" to the far left of the cell and "121212" to the far right Can this be done? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to identify text from a autofiltered list using formulas | Excel Worksheet Functions | |||
converting concatenated text strings into formulas | Excel Worksheet Functions | |||
Concatenating two formulas | Excel Discussion (Misc queries) | |||
Concatenating IF(AND formulas | Excel Discussion (Misc queries) | |||
Excel formulas to create large blocks of text | Excel Discussion (Misc queries) |