Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract data up to a certain character
hi all, I'm having trouble extracting data up on a cell up to a certain character, for example up to "/" for example this cell data: David Staton / 102 oak st I just need "David Station" and leave "/ 102 oak" st alone thanks for any pointers. mark -- markahpi ------------------------------------------------------------------------ markahpi's Profile: http://www.excelforum.com/member.php...o&userid=37571 View this thread: http://www.excelforum.com/showthread...hreadid=571997 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract data up to a certain character
=LEFT(A1,FIND("/",A1)-1)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "markahpi" wrote in message ... hi all, I'm having trouble extracting data up on a cell up to a certain character, for example up to "/" for example this cell data: David Staton / 102 oak st I just need "David Station" and leave "/ 102 oak" st alone thanks for any pointers. mark -- markahpi ------------------------------------------------------------------------ markahpi's Profile: http://www.excelforum.com/member.php...o&userid=37571 View this thread: http://www.excelforum.com/showthread...hreadid=571997 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract data up to a certain character
forgot asking on how to extract the other part "102 oak st" only? -- markahpi ------------------------------------------------------------------------ markahpi's Profile: http://www.excelforum.com/member.php...o&userid=37571 View this thread: http://www.excelforum.com/showthread...hreadid=571997 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract data up to a certain character
=MID(A1,FIND("/",A1)+1,99)
You can also use DataText To Columns with a delimiter of / -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "markahpi" wrote in message ... forgot asking on how to extract the other part "102 oak st" only? -- markahpi ------------------------------------------------------------------------ markahpi's Profile: http://www.excelforum.com/member.php...o&userid=37571 View this thread: http://www.excelforum.com/showthread...hreadid=571997 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract data up to a certain character
thanks bob! :) -- markahpi ------------------------------------------------------------------------ markahpi's Profile: http://www.excelforum.com/member.php...o&userid=37571 View this thread: http://www.excelforum.com/showthread...hreadid=571997 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract data up to a certain character
You have more responses at your other post.
markahpi wrote: forgot asking on how to extract the other part "102 oak st" only? -- markahpi ------------------------------------------------------------------------ markahpi's Profile: http://www.excelforum.com/member.php...o&userid=37571 View this thread: http://www.excelforum.com/showthread...hreadid=571997 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |