PDA

View Full Version : Excel data export from sharepoint



cmaegray
2016-07-26, 01:37 AM
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;#?

Pecoflyer
2016-07-26, 07:48 AM
Perhaps Ctrl+H

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

Click Replace All

(if needed you can record this as a macro for further use)

cmaegray
2016-07-26, 01:24 PM
Thanks Pecoflyer, but no go. I also tried ---;#* That's not working either - I'll keep plugging at it!

Pecoflyer
2016-07-26, 03:56 PM
There is no reason why it should not work