| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
=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. |
|
#4
|
|||
|
|||
|
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. |
|
#5
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Changing column size w/o losing text | New Users to Excel | |||
| how do i convert a row of data into a column in another excel wor. | Excel Worksheet Functions | |||
| How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
Linear Mode
