Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding and extracting text in a cell, splitting into smaller chun
Hi all,
I've tried to do this with a combination of search and right/left, but end up with a 'too many arguments' problem once I try to build in error checks etc. What I'm trying to do is take the contents of a cell and split it into component parts within the same sheet... I have something like 1234;5678;9999;0000 and I want to get cells containing 1234, 5678, 9999 & 0000 seperated. The trouble is the amount of data can vary, and I need to account for situations with between zero ";" characters up to six of them. Any ideas folks? Thanks, Marc |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding and extracting text in a cell, splitting into smaller chun
Hi,
Text to colums will do that with the delimiter set as ; Mike "Marc T" wrote: Hi all, I've tried to do this with a combination of search and right/left, but end up with a 'too many arguments' problem once I try to build in error checks etc. What I'm trying to do is take the contents of a cell and split it into component parts within the same sheet... I have something like 1234;5678;9999;0000 and I want to get cells containing 1234, 5678, 9999 & 0000 seperated. The trouble is the amount of data can vary, and I need to account for situations with between zero ";" characters up to six of them. Any ideas folks? Thanks, Marc |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding and extracting text in a cell, splitting into smaller
Hi Mike,
what I'm needing is a function equivalent sadly. Here's a little background: I have a list of invoices and a list of purchase orders within a workbook populated directly from a database using MS Query. The invoice list should have a single purchase order number for each entry, but in some cases they have multiple numbers joined by the semi-colon. I'm needing to have a function on the invoices data sheet that can identify these numbers and check if they exist in the purchase orders sheet. I can do the checking part of the function, but splitting out the contents in order to do the checking is stumping me. Marc "Mike H" wrote: Hi, Text to colums will do that with the delimiter set as ; Mike "Marc T" wrote: Hi all, I've tried to do this with a combination of search and right/left, but end up with a 'too many arguments' problem once I try to build in error checks etc. What I'm trying to do is take the contents of a cell and split it into component parts within the same sheet... I have something like 1234;5678;9999;0000 and I want to get cells containing 1234, 5678, 9999 & 0000 seperated. The trouble is the amount of data can vary, and I need to account for situations with between zero ";" characters up to six of them. Any ideas folks? Thanks, Marc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting a file with lookup functions into smaller parts | Excel Worksheet Functions | |||
Splitting text in a cell | Excel Worksheet Functions | |||
Format number to display % symbol smaller than onther text in cell | Excel Discussion (Misc queries) | |||
Splitting and Extracting data | Excel Discussion (Misc queries) | |||
splitting text in a cell.. | Excel Discussion (Misc queries) |