| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging cells must be text format
I have two cells I need to merge: The first:
CELL A1: CREDIT LIMIT CELL A2: 10000000 The end result needs to look like this: CREDIT LIMIT $ 10,000,000 Please help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merging cells must be text format
Hi
try =A1 & " " & TEXT(A2,"$ 0,0") -- Regards Frank Kabel Frankfurt, Germany Programmer wanna be wrote: I have two cells I need to merge: The first: CELL A1: CREDIT LIMIT CELL A2: 10000000 The end result needs to look like this: CREDIT LIMIT $ 10,000,000 Please help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merging cells must be text format
Thank for your help.
Unfortunately the credit limit values change depending on account the formula is assigned to. Is there a way to automatically, through a formula determine the amount of characters, then assign the commas accordingly? thanks "Frank Kabel" wrote in message ... Hi try =A1 & " " & TEXT(A2,"$ 0,0") -- Regards Frank Kabel Frankfurt, Germany Programmer wanna be wrote: I have two cells I need to merge: The first: CELL A1: CREDIT LIMIT CELL A2: 10000000 The end result needs to look like this: CREDIT LIMIT $ 10,000,000 Please help. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merging cells must be text format
Hi
this format is just for adding 'thousand-delimiters'. So It should work regardless of the value in cell A2 -- Regards Frank Kabel Frankfurt, Germany Programmer wanna be wrote: Thank for your help. Unfortunately the credit limit values change depending on account the formula is assigned to. Is there a way to automatically, through a formula determine the amount of characters, then assign the commas accordingly? thanks "Frank Kabel" wrote in message ... Hi try =A1 & " " & TEXT(A2,"$ 0,0") -- Regards Frank Kabel Frankfurt, Germany Programmer wanna be wrote: I have two cells I need to merge: The first: CELL A1: CREDIT LIMIT CELL A2: 10000000 The end result needs to look like this: CREDIT LIMIT $ 10,000,000 Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging text from two cells | Excel Discussion (Misc queries) | |||
| Merging multiple cells with text | Excel Discussion (Misc queries) | |||
| Text from 2 Cells merging to another...Help | Excel Discussion (Misc queries) | |||
| Merging cells and text wrap | New Users to Excel | |||
| Merging cells with text as one line | Excel Worksheet Functions | |||
Linear Mode
