Convert text to column
 

Hi,

I have 4000 rows of data that start with "01Exxx.00" and tried using the
"convert text to column" function to get rid of digits after the period.
However, it all turned into "1E+123.. 1E+233".

What can I do to make the numbers show "01E123" without the ".00"? Thanks.

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

"JN" wrote in message
...
Hi,

I have 4000 rows of data that start with "01Exxx.00" and tried using the
"convert text to column" function to get rid of digits after the period.
However, it all turned into "1E+123.. 1E+233".

What can I do to make the numbers show "01E123" without the ".00"? Thanks.

=LEFT(A1,FIND(".",A1)-1)
then fill down.

"JN" wrote in message
...
Hi,

I have 4000 rows of data that start with "01Exxx.00" and tried using the
"convert text to column" function to get rid of digits after the period.
However, it all turned into "1E+123.. 1E+233".

What can I do to make the numbers show "01E123" without the ".00"? Thanks.

Thanks!! What do the LEFT and Find functions do here? Also, can I apply this
formula for any number text with "E" in it?

"Bob Umlas" wrote:

=LEFT(A1,FIND(".",A1)-1)
then fill down.

"JN" wrote in message
...
Hi,

I have 4000 rows of data that start with "01Exxx.00" and tried using the
"convert text to column" function to get rid of digits after the period.
However, it all turned into "1E+123.. 1E+233".

What can I do to make the numbers show "01E123" without the ".00"? Thanks.

Thanks. What is the different for this "Search" function from "find"?

"N Harkawat" wrote:

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

"JN" wrote in message
...
Hi,

I have 4000 rows of data that start with "01Exxx.00" and tried using the
"convert text to column" function to get rid of digits after the period.
However, it all turned into "1E+123.. 1E+233".

What can I do to make the numbers show "01E123" without the ".00"? Thanks.