N
Nancy
I have imported a text file into Excel 2003 using the Import Wizard,
and I have specified that each column is "text" during the wizard. I
want to combine two text fields into one value so I can use the more
elaborate value in a pivot table later. For example:
A1 = ABC
B1 = Welcome message
C1 = gobbledygook
I want to insert a column before column C that would say "ABC-Welcome
message".
I right-click on column C and choose Insert.
I type in this formula into the new C1: =A1&"-"&B1
Cell C1 now shows the formula, not the value.
If I type the formula way over in an unused column Z, then "ABC-
Welcome message" shows up just fine.
Is there some trick to inserting a column into a spreadsheet so the
formula will work? What am I missing?
Thanks in advance,
and I have specified that each column is "text" during the wizard. I
want to combine two text fields into one value so I can use the more
elaborate value in a pivot table later. For example:
A1 = ABC
B1 = Welcome message
C1 = gobbledygook
I want to insert a column before column C that would say "ABC-Welcome
message".
I right-click on column C and choose Insert.
I type in this formula into the new C1: =A1&"-"&B1
Cell C1 now shows the formula, not the value.
If I type the formula way over in an unused column Z, then "ABC-
Welcome message" shows up just fine.
Is there some trick to inserting a column into a spreadsheet so the
formula will work? What am I missing?
Thanks in advance,