close
I have a list of names in one column and need a formula to split the info in
to to two columns ie First Name and then Surname. can anyone help?
If you have a single space separating the first name from the surname,
you can highlight the column then use Data | Text-to-columns and
specify delimited with space as the delimiter.
Hope this helps.
Pete
全站熱搜
留言列表
