| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to pick up data from left of a space starting from the right?
=VALUE(MID(A2, FIND(" ", A2), 256))
where the string in in A2 Or you could use Data - Text to Columns to split the values apart. -- HTH... Jim Thomlinson "pgarcia" wrote: 1 4210210 134.40 2 30362920 395.40 3 820401-2 116.20 4 728435514 5152.06 5 820401-1 194.57 6 820501-1 365.90 7 42111438 1158.50 I need to find the space from the right to left then bring back left of that mark to the right. Should look like this: 134.40 395.40 116.20 5152.06 194.57 365.90 1158.50 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dollar sign left justified - data right justified - large space | Excel Discussion (Misc queries) | |||
| pick up last occupied cell to the left macro | New Users to Excel | |||
| HOW TO CHANGE CELL STARTING FROM RIGHT TO LEFT | Excel Discussion (Misc queries) | |||
| read characters starting from the right until a space is reached | Excel Discussion (Misc queries) | |||
| removing a space from starting of the text | Excel Worksheet Functions | |||
Hybrid Mode
