| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting substring
Hi,
Please find the follwoing data abcd efg [R51K] abc efg[R52E] abcd efghij [R31K] From this i need the data without [Rxxx]. please suggest how to do this Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
extracting substring
Try
=LEFT(A1,FIND("[",A1)-1) OR =TRIM(LEFT(A1,FIND("[",A1)-1)) -- Jacob "Rajesh" wrote: Hi, Please find the follwoing data abcd efg [R51K] abc efg[R52E] abcd efghij [R31K] From this i need the data without [Rxxx]. please suggest how to do this Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
extracting substring
Another way using REPLACE()
=REPLACE(A1,FIND("[",A1),99,) -- Jacob "Rajesh" wrote: Hi, Please find the follwoing data abcd efg [R51K] abc efg[R52E] abcd efghij [R31K] From this i need the data without [Rxxx]. please suggest how to do this Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
extracting substring
Thank you so much Jacob. it works...
"Jacob Skaria" wrote: Try =LEFT(A1,FIND("[",A1)-1) OR =TRIM(LEFT(A1,FIND("[",A1)-1)) -- Jacob "Rajesh" wrote: Hi, Please find the follwoing data abcd efg [R51K] abc efg[R52E] abcd efghij [R31K] From this i need the data without [Rxxx]. please suggest how to do this Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| substring | Excel Discussion (Misc queries) | |||
| Extracting a SubString | Excel Discussion (Misc queries) | |||
| Finding a Substring? | Excel Worksheet Functions | |||
| Substring | Excel Discussion (Misc queries) | |||
| Substring | Excel Discussion (Misc queries) | |||
Linear Mode
