Right function
Hi Paul,
Hopefully this quick answer will help you out.
Use the 'Text to Columns' function
Assuming you have a space between the first/middle/last names
Highlight the data in question,
select 'text to column'
tick the box 'delimited' ...next
tick the box 'space' ... next & finish
Hope this helps
Cheers
Paul
"Paul S" wrote:
I have a spreadsheet of 400 names consisting of first name, middle initial
and surname (e.g. Joe x Blogs) and want to create a new column that just
gives me the surname. I'm sure that it can be done with the Right function
but just can't find the correct method to do it. Any help appreciated. Thanks
|