Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WITHIN CELL, PARSE END OF TEXT, START OF NUMBER
Any suggestions on parsing data as below. I have a long list.
The one thing they all share in common is that they begin with text and end with two numbers. Spaces can be anywhere within. Accor SA France 3,300,000 177,214,917 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
WITHIN CELL, PARSE END OF TEXT, START OF NUMBER
If your data is in Col A
then enter this in B1 =MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$255),1)),0) and press CTRL-SHIFT-ENTER this will give you the position of first number in the string Then you can use =Left(A1,B1-1) to get the text string =MID(A1,B1,Len(A1)-B1+1) to get the numbers You can then split the numbers on the blank in between by Data-Text to columns "ORLANDO V" wrote: Any suggestions on parsing data as below. I have a long list. The one thing they all share in common is that they begin with text and end with two numbers. Spaces can be anywhere within. Accor SA France 3,300,000 177,214,917 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
WITHIN CELL, PARSE END OF TEXT, START OF NUMBER
See one answer in my reply to your prior post...
Please don't post multiple times - it just tends to fragment any answers you get and to waste the time of those answering posts that already have replies. In article , ORLANDO V wrote: Any suggestions on parsing data as below. I have a long list. The one thing they all share in common is that they begin with text and end with two numbers. Spaces can be anywhere within. Accor SA France 3,300,000 177,214,917 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of days up to an empty cell then start over again | Excel Discussion (Misc queries) | |||
Default text to start at top of cell? | Excel Discussion (Misc queries) | |||
parse text string | Excel Worksheet Functions | |||
Parse text & numbers & format | Excel Worksheet Functions | |||
Parse text & Numbers | Excel Worksheet Functions |