Concatinating a string of numbers - how?

  • Thread starter Thread starter drod
  • Start date Start date
D

drod

Okay, so here is my dilema.

In a column, I have numbers like 123456789 and 234567890 (all are
digits long). However, when you select the cell, you can see that eac
of them is preceeded by a " ' " character that apparently is hidde
from view. For example '123456789 and '234567890.

I need to format these cells, but in order to do so, I need to get ri
of the " ' " character preceeding each of the numbers in my column. I
there a way to concatenate or convert each of the numbers such tha
they no longer have the " ' " preceeding them?

Thanks in advance
 
Hi

The ' merely tells Excel that what is following is text. It does not display
in Excel but means that the cell is treated as a text cell. The benefit of
this is that leading zeroes show and 'numbers' of more than 15 digits will
show (but cannot be calculated)
If you use:
=A2&B2
this will concatenate the two cells - ignoring the '

Hope this helps.
Andy.
 
Back
Top