Yusuf
Active Member
- Joined
- Jun 1, 2004
- Messages
- 337
Hi
I'm having difficulty understanding why my LEFT and RIGHT functions aren't doing what I want.
I have a column with addresses and I'm trying to split up certain parts into different columns to mail merge.
Eg in cell A1;
25 Speed Lane Edinburgh Scotland
If I use in B1 =LEFT(A1,FIND(" ",A1,1))
I get the number of the house, which is what I'm looking for.
If I try to get the last part, ie "Scotland"
Eg. =RIGHT(A1,FIND(" ",A1,1))
I don't get the full name but the last two letters only.
In some cells I return three letters of the last town name
Please help with a solution.
I'm having difficulty understanding why my LEFT and RIGHT functions aren't doing what I want.
I have a column with addresses and I'm trying to split up certain parts into different columns to mail merge.
Eg in cell A1;
25 Speed Lane Edinburgh Scotland
If I use in B1 =LEFT(A1,FIND(" ",A1,1))
I get the number of the house, which is what I'm looking for.
If I try to get the last part, ie "Scotland"
Eg. =RIGHT(A1,FIND(" ",A1,1))
I don't get the full name but the last two letters only.
In some cells I return three letters of the last town name
Please help with a solution.