Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate values
Working with Excel, I am trying to merge text from two columns into one
(first and last names). I've used two strategies: =A1," ", &B1 and=concatenate(A2, " ",A3). In both cases, all I see in the cell is the formula, not the resulting name. When I use the concatenate function, the correct name shows in the Function Arguments window in which I do the work. How do I get this resulting name to actually show up in the cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate values
Try hitting CTRL+~
Sounds like you are just viewing formulas instead of values... "Flint springs" wrote: Working with Excel, I am trying to merge text from two columns into one (first and last names). I've used two strategies: =A1," ", &B1 and=concatenate(A2, " ",A3). In both cases, all I see in the cell is the formula, not the resulting name. When I use the concatenate function, the correct name shows in the Function Arguments window in which I do the work. How do I get this resulting name to actually show up in the cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate values
Hi,
in excel 2007 Formulas,Formula auditing, click in show Formulas "Flint springs" wrote: Working with Excel, I am trying to merge text from two columns into one (first and last names). I've used two strategies: =A1," ", &B1 and=concatenate(A2, " ",A3). In both cases, all I see in the cell is the formula, not the resulting name. When I use the concatenate function, the correct name shows in the Function Arguments window in which I do the work. How do I get this resulting name to actually show up in the cell? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate values
You are either in "View Formulas" mode or the cell was pre-formatted as
text. Hit CTRL + '(backquote above Tab key) to toggle the formula view. If no joy, format to General then F2 and ENTER Gord Dibben MS Excel MVP On Fri, 22 May 2009 07:42:35 -0700, Flint springs <Flint wrote: Working with Excel, I am trying to merge text from two columns into one (first and last names). I've used two strategies: =A1," ", &B1 and=concatenate(A2, " ",A3). In both cases, all I see in the cell is the formula, not the resulting name. When I use the concatenate function, the correct name shows in the Function Arguments window in which I do the work. How do I get this resulting name to actually show up in the cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate Values with VBA | Excel Discussion (Misc queries) | |||
CONCATENATE on separated values | New Users to Excel | |||
Concatenate values IF() | Excel Worksheet Functions | |||
Concatenate with the formula values | Excel Worksheet Functions | |||
Concatenate values | Excel Worksheet Functions |