Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all , i was wanting too get a function which trims off the (A) part of col A but leaves the entire rest of the cell . Names can vary in lenght . Have tried standard trim but of course ends up trimming last few letters of each name .
Answers required are in col B .
Thanks .
Answers required are in col B .
Thanks .
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | Jockey | Answer | ||
2 | Ryan Bishop | Ryan Bishop | ||
3 | KC Walters (A) | KC Walters | ||
4 | Maija Vance (A) | Maija Vance | ||
5 | Jonathan Riddell | Jonathan Riddell | ||
6 | Vinnie Colgan | Vinnie Colgan | ||
7 | Sam Spratt | Sam Spratt | ||
8 | Lisa Allpress | Lisa Allpress | ||
9 | Jonathan Riddell | Jonathan Riddell | ||
10 | Rory Hutchings (A) | Rory Hutchings | ||
11 | Lisa Allpress | Lisa Allpress | ||
12 | Matthew Cameron | Matthew Cameron | ||
13 | Lynsey Satherley | Lynsey Satherley | ||
14 | Shankar Muniandy (A) | Shankar Muniandy | ||
15 | Lee Callaway | Lee Callaway | ||
16 | Jillian Morris | Jillian Morris | ||
17 | Ashley McKay (A) | Ashley McKay | ||
18 | David Walsh | David Walsh | ||
19 | James McDonald (A) | James McDonald | ||
20 | Matthew Cameron | Matthew Cameron | ||
21 | Lisa Allpress | Lisa Allpress | ||
22 | James McDonald (A) | James McDonald | ||
23 | Trudy Thornton | Trudy Thornton | ||
24 | Mark Hills | Mark Hills | ||
25 | Mereana Hudson (A) | Mereana Hudson | ||
26 | Hayden Tinsley | Hayden Tinsley | ||
27 | David Walker | David Walker | ||
Sheet1 |