Scottish Dude
New Member
- Joined
- Feb 16, 2005
- Messages
- 3
Can anyone help me.
I have a column full of contact names. Each cell has Init(s) Name. Can anyone help me with some code to change each cell in the column to read Name Init(s)
I have been using the functions , left, mid, right to do this, But as each cell could contain any number of inits this is very time consuming. I have been trying to work out how to do this by using function to find the space between the inits and name then try to select a nos of characters either side of the space.
I am getting nowhere.
using excel (office xp)
I have a column full of contact names. Each cell has Init(s) Name. Can anyone help me with some code to change each cell in the column to read Name Init(s)
I have been using the functions , left, mid, right to do this, But as each cell could contain any number of inits this is very time consuming. I have been trying to work out how to do this by using function to find the space between the inits and name then try to select a nos of characters either side of the space.
I am getting nowhere.
using excel (office xp)