I am trying to break up a column in my excel file but I am getting an Error

FRP_Salesforce <- read_excel("~/FRP Salesforce.xlsx")
View(FRP_Salesforce)

df <- FRP_Salesforce %>% separate(FRP Donor Address, c("Address", "City"))

You don't say what error you are getting, so it's really hard to provide any help. The first thing I see is that the column name has spaces in it. Try putting the column name in back ticks.

df <- FRP_Salesforce %>% separate(`FRP Donor Address`, c("Address", "City"))

On a standard US keyboard, the back tick is just to the left of the 1 key.
It is best to avoid column names with spaces. If you can edit the names to use underscores instead of spaces, I recommend you do that.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.