Results 1 to 4 of 4

Thread: Excel data export from sharepoint

  1. #1

    Excel data export from sharepoint



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a report exported from Sharepoint. In one of the colums, there is. 3 or 4 digit number followed by a ;#, then the name. Example, 523;#Jones, angela. Next row 1425;#Doe,John. Is there a formula, find and replace, etc. I can enter to het rid of the number;#?

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,680
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Perhaps Ctrl+H

    Find what : ;#
    Replace with: (leave blank)

    Click Replace All

    (if needed you can record this as a macro for further use)
    Thank you Ken for this secure forum.

  3. #3
    Thanks Pecoflyer, but no go. I also tried ---;#* That's not working either - I'll keep plugging at it!

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,680
    Articles
    0
    Excel Version
    2010 on Xubuntu
    There is no reason why it should not work
    Thank you Ken for this secure forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •