merryperson
Board Regular
- Joined
- Apr 27, 2005
- Messages
- 72
I have a column with usually numeric digits and then a name of a person.
I.e C11883 Dave Smith
C11 Dave Jones
D11111 William Brian Johnson
I wish to create a new column removing the first word to give the results
Dave Smith
Dave Jones
William Brian Johnson
I have used the MiD function but the length of the first wod varies and so it doesnt wok
HELP please
I.e C11883 Dave Smith
C11 Dave Jones
D11111 William Brian Johnson
I wish to create a new column removing the first word to give the results
Dave Smith
Dave Jones
William Brian Johnson
I have used the MiD function but the length of the first wod varies and so it doesnt wok
HELP please