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 |
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) |