Here's what I want to do- Please Help

  • Thread starter Thread starter Sam12345
  • Start date Start date
S

Sam12345

In one column I have a list of names (ie - U4, U5 U6, U7, U8).
Some have a space in between them (ie- N Jansen).

So I want to have those names listed and seperated by commas in anothe
larger box. (ie- McDonald, N Jansen, Daniels, Hoffman, W Miller).

But I want a formula because I may have to end up changing one or tw
of those names in the furture.

This is what I have tried entering:
=U4&", "&U5&", "&U6&", "&U7&", "&U8
But when I press enter just the formula shows up.
And when I press "edit formula, it gives me an example of exactley wha
I want them to show. So what gives? I have a number formula correctl
working on the same sheet, so I didn't think it was on "show formulas"

So is the formula wrong or what? I would really appreciatte any help.
Thank you
 
Hi
probably your cell is formated as 'Text'. goto 'format - Cells' and
change the format to 'General'. After this re-enter the formula

If this does not help goto 'Tools - Options - view' and make sure that
'Formulas' is NOT checked
 
I tried those both and still no success.

Is there any other way to write that formula which I can try?

It just doesn't make any sense because when I press 'edit formula' i
shows me what I want to see yet the formula itself is still shown i
that box.
And yes formulas is not checked - other formulas are correctly shown o
that page
 
Hi
and the format of this cell is not 'Text' (Have you checked this in
'Format - Cells')?
 
Okay I got. I changed the format while the formula was stil written i
the box. So I delted and wrote in all over again with teh format a
'General' and it worked.
Thanks a lot for your help
 
Hi Sam,
For a little bit more information on what you did to fix it see
http://google.com/[email protected]

Yours is the opposite but until you reenter a change in the format does not
take effect. Since you have to reenter a formula and aren't in the programming
group any of these would also work after changing the format.
-- F2 then Enter
-- Change "=" to "=" using Ctrl+H
-- select an empty cell, copy with Ctrl+C, select the cells to be reentered such
as a column, Edit, Paste Special, Add

Still more information at
http://www.mvps.org/dmcritchie/excel/join.htm#reenter
http://www.mvps.org/dmcritchie/excel/join.htm#debugformat


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top