Also a good solution this is very useful as well as the solution by Bob
Phillips



"Dave Peterson" wrote:

Maybe you can select the column and do
Data|text to columns
delimited by spaces

Terry wrote:

I have a columnn full of strings of varaible length and content which contain
0 to 4 spaces interspersed within the string
eg "1 1p 3 7c " or "2 4 1" or "1 2 x 4"
I want to extract the values between the spaces. If I know the number of
spaces and the position of each space I can use the LEFT and MID functions to
extract the values i want.
I am not fussed as to whether this is done within Excel sheet adjacent cells
or within a VBA procedure and returned to 4 adjacent cells.

--

Dave Peterson