Split cell by numer

  • Thread starter Thread starter gielwijg
  • Start date Start date
G

gielwijg

Hello,

Below are a couple of cells which I want to split:

CEL

ewf ewf wef 5
wef 6
wfwef 23

In this way I want to split them, so space is not an option.

CEL 1[/B]
EWF EWF WEF
WEF
WFWEF

CEL
5
6
23



Who know a function for this?

Thank you
 
Hi,

Asuming the string is in [A1], try these formulae:

to get the number:
=--MID(A1,FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,LEN(A1))

to get the text:
=LEFT(A1,FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))-1)

You could also use the menu Data>Text to columns... to parse the string
using space as delimiter.

Regards,
KL
 
Back
Top