Seperate/Split celinput

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm currently working on the following:

Cel A1 says "3456 AA Utrecht ERDS". I want to split this into
1. 3456 AA
2. Utrecht
3. Old

Is there a formula for splitting cel A1 into these 3 parts. If Yes...Is this
formula also working when cel A2 says "3455 DF Amsterdam ERDSERTR"

thx
 
Hello,

Try having a look at the LEFT, MID & RIGHT Excel worksheet functions. Or
you could use Text to Columns (from the Data menu) to seperate the data into
individual cells (my preferred method generally) as to provide a higher
level of manipulation.
 
Thank Zack for your reaction,
But I have to make one formula that does it all. No matter what size the
content is.
Bye
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split numbers in cell 6
splitting text within parenthese into new column 1
Do you have what it takes... 2
SUMPRODUCT- double unary vs. * 2
How to use the IF function to resolved more than one creteria 4
VBA Multiple Line handling with Split() 1
Wanted to show formula result, not formula. How??? 5
getting data from a set of closed files 3

Back
Top