Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old December 6th 04, 01:39 AM
fantasma
 
Posts: n/a
Default

HEY! That did it! Thanks! Question: Do you think I must have erroneously
checked this at some point in time? This computer/Excel program is only a
few months old ...... but I've done calculations with it previously. (Maybe
I erroneously turned it on when trying to get this working??) Any comments
as to how this went wrong??

Thanks for your help.



"Dave Peterson" wrote:

Are you viewing formulas?

Tools|options|View Tab
Uncheck Formulas if it's checked.



fantasma wrote:

I have no spaces in the formula ... preceding or within the formula.

"Dave Peterson" wrote:

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get either of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ... and
now
I want to re-combine two of them. I've tried to follow instructions for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.




--

Dave Peterson


--

Dave Peterson


  #12   Report Post  
Old December 6th 04, 03:43 PM
CarlosAntenna
 
Posts: n/a
Default

There is a hotkey to toggle this feature. It is ctrl` that's the key on the
top row next to 1. Maybe the cat was walking on the keyboard again.

Carlos

"fantasma" wrote in message
...
HEY! That did it! Thanks! Question: Do you think I must have

erroneously
checked this at some point in time? This computer/Excel program is only a
few months old ...... but I've done calculations with it previously.

(Maybe
I erroneously turned it on when trying to get this working??) Any

comments
as to how this went wrong??

Thanks for your help.



"Dave Peterson" wrote:

Are you viewing formulas?

Tools|options|View Tab
Uncheck Formulas if it's checked.



fantasma wrote:

I have no spaces in the formula ... preceding or within the formula.

"Dave Peterson" wrote:

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get

either of
the techniques to work. (I tried the same when it was outlined MS

Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4

letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1

..... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding'

the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3

columns) ... and
now
I want to re-combine two of them. I've tried to follow

instructions for
this
in the HELP area but cannot merge the two columns. (One

contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/

XP.




--

Dave Peterson


--

Dave Peterson



  #13   Report Post  
Old December 7th 04, 02:29 AM
Dave Peterson
 
Posts: n/a
Default

Darn cats! <vbg

CarlosAntenna wrote:

There is a hotkey to toggle this feature. It is ctrl` that's the key on the
top row next to 1. Maybe the cat was walking on the keyboard again.

Carlos

"fantasma" wrote in message
...
HEY! That did it! Thanks! Question: Do you think I must have

erroneously
checked this at some point in time? This computer/Excel program is only a
few months old ...... but I've done calculations with it previously.

(Maybe
I erroneously turned it on when trying to get this working??) Any

comments
as to how this went wrong??

Thanks for your help.



"Dave Peterson" wrote:

Are you viewing formulas?

Tools|options|View Tab
Uncheck Formulas if it's checked.



fantasma wrote:

I have no spaces in the formula ... preceding or within the formula.

"Dave Peterson" wrote:

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get

either of
the techniques to work. (I tried the same when it was outlined MS

Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4

letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1

.... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding'

the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3

columns) ... and
now
I want to re-combine two of them. I've tried to follow

instructions for
this
in the HELP area but cannot merge the two columns. (One

contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/

XP.




--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel column headings from numbers to letters happygolucky Excel Discussion (Misc queries) 2 January 21st 05 06:15 PM
no row numbers or column letters DISPLAYED RagDyer Excel Discussion (Misc queries) 3 January 11th 05 08:28 PM
Finding Numbers with Cells that also contain letters Adam Excel Discussion (Misc queries) 7 December 29th 04 02:41 PM
how to sum up letters instead of numbers? Iviio Excel Discussion (Misc queries) 4 December 27th 04 12:22 AM
How do I change column labels from numbers to letters in Excel? AllisonCincy Excel Discussion (Misc queries) 2 December 9th 04 12:55 AM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017