Left Right Mid
 

I have data in cell A1 that looks like this. I want to be able to
seperate it with the left right mid functions into B1,C1, D1, E1, F1,
and get rid of the comma's. Any help would be greatly appreciated.

25632, 27865, 456456, 987456, 789456

thanks Glenn

Left Right Mid
 

It would be easier to use Data | Text to Columns | delimited by a comma and
space. It wouldn't matter then how long the numeric strings were.

It looks as though you have spaces in there too. Assuming there a

B1 =MID(A1,1,5)
C1 =MID(A1,8,5)
D1 =MID(A1,15,6)
E1 =MID(A1,23,6)
F1 =MID(A1,31,6)

If there are no spaces, adjust the start positions.

You don't need to use LEFT and/or RIGHT

Regards

Trevor


"QTGlennM" wrote in message
oups.com...
I have data in cell A1 that looks like this. I want to be able to
seperate it with the left right mid functions into B1,C1, D1, E1, F1,
and get rid of the comma's. Any help would be greatly appreciated.

25632, 27865, 456456, 987456, 789456

thanks Glenn

Left Right Mid
 

Hi Ron,

and how would I do that?

I am as advanced as being able to click "fx"
in the formula toolbar and select "all".
But there is no "data" nor "text to column".

I could write a function myself, yes, no problem.
But it is built in already, as you say.
Only, how to find it?

--
Greetings from Bavaria, Germany

Helmut Weber

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Left Right Mid
 

Select the column with your data and go to the Data menu in the menubar
then choose Text to columns and follow the steps

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Helmut Weber" wrote in message ...
Hi Ron,

and how would I do that?

I am as advanced as being able to click "fx"
in the formula toolbar and select "all".
But there is no "data" nor "text to column".

I could write a function myself, yes, no problem.
But it is built in already, as you say.
Only, how to find it?

--
Greetings from Bavaria, Germany

Helmut Weber

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Left Right Mid
 

Hi Ron,

yes,

Danke schoen.

--

Helmut Weber

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Left Right Mid
 

one way

Sub test()
arr = Split(Trim(Range("a1")), ",")
Range("b1:f1").Value = arr
End Sub


Gary


"QTGlennM" wrote in message
oups.com...
I have data in cell A1 that looks like this. I want to be able to
seperate it with the left right mid functions into B1,C1, D1, E1, F1,
and get rid of the comma's. Any help would be greatly appreciated.

25632, 27865, 456456, 987456, 789456

thanks Glenn