Combining Data from Cells

[Ruzzo]

If I have the following:

Cell A1:
G12828

Cell B1:
11230

How do I get cell C1 to read as follows (a period between the two entries):
G12828.11230

Thank you advance.

Ruzzo

 

[Trouttrap2]

Try:

=A1&"."&B1

 

[Ruzzo]

Thank you.
The result puts a space between the first set of numbers and the period.
Is there anyway to get rid of that space?

 

[Ruzzo]

Nevermind my last question...the original data had a space.

Thanks again.
Ruzzo

 

[Rick Rothstein]

That means your data has a space after it. If you don't want to "purify" your data, then you can modify TroutTrap2's code this way...

=TRIM(A1&"."&B1)

Now, if the above does not work, then that would mean your space is actually a non-breaking space (ASCII 160) which could come from copying data from the web. If that is the case, then try this formula instead...

=SUBSTITUTE(A1&"."&B1,CHAR(160),"")