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

R

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??
 
J

JE McGimpsey

Randy Wood said:
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).
Click to expand...

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)
 
Top