Viewing 4 posts - 1 through 4 (of 4 total)
  • One for the Excel gurus
  • piedidiformaggio
    Free Member

    I have a column which contains names in the format surname,firstname

    I need to change this to firstname.surname

    Can’t see a text formula for this. Anyone know if there is one or an easy way to do this?

    Thanks

    WackoAK
    Free Member

    You can use the “text to columns” function in the data menu to split the field into firstname and surname then it’s easy enough to create what you need?

    lemonysam
    Free Member

    I haven’t got excel on this machine to check but…

    =RIGHT(A1,LEN(A1)-SEARCH(“,”,A1,1)) + “.” + LEFT(A1, SEARCH(“,”,A1,1))

    or something similar

    Fresh Goods Friday 696: The Middling Edition

    Fresh Goods Friday 696: The Middlin...
    Latest Singletrack Videos
    piedidiformaggio
    Free Member

    WackoAK wins the Gold Star

    This place is bloody brilliant 😀

Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘One for the Excel gurus’ is closed to new replies.