How to do?: Copy and Paste a partial of a cell

[Randy Wood]

Lets say I have a column(A) with some data like the following and I wish
to only copy the first part of the cell and put into the next direct
column(B).

Here is an example of what is needed.(NEED TO TRANSFER INFO THAT IS
LEFT OF THE FIRST period .



COLUMN A Column B

483.6.1 483


485C.6.3 485C






496557.11.16 496557





505.7.28 505








Any ideas??

 

[JE McGimpsey]

Lets say I have a column(A) with some data like the following and I wish
to only copy the first part of the cell and put into the next direct
column(B).

Well, first, I'd ask whether you really need to keep the info in column
A. If not, you can use Data/Text to Columns, delimited, using a period.

If so, one way:

B1: =LEFT(A1,FIND(".",A1)-1)

which produces a text value. If you want a numeric value you can use

=--LEFT(A1,FIND(".",A1)-1)

 

[Randy Wood]

Thanks JE !!
The first formula works great!! Appreciate the help.