Left Right Mid

[QTGlennM]

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

 

[Ron de Bruin]

Why not use Data>Text to columns ?

 

[Trevor Shuttleworth]

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 are:

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

 

[Helmut Weber]

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"

 

[Ron de Bruin]

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

 

[Helmut Weber]

Hi Ron,

yes,

Danke schoen.

--

Helmut Weber

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

 

[Gary Keramidas]

one way

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


Gary