Is there an opposite function to "Concatenate" in Excel?
is there a way to do a folmula to find the space, add and comma and swap
everything before the space with everything after the space.
Jennifer Dolly in A2
Fomula in B2 something to do with =find(" ") and RIGHT & LEFT... etc...
so it becomes Dolly, Jennifer
??
I do the text to columns and then = B2&","&A2, but am hoping to save myself
some time.
"Duke Carey" wrote:
Data-Text to Columns...Delimited
How is the data orgainzed? If it's "Bob Dole" then the delimiter is a
space character. If it's "Dole, Bob" then the delimiter is a comma
You'll need an empty column to the right of the names. Also, if it's a
space delimiter you'll need to do some checking & manual cleanup because of
names such as "Billy Joe Davis"
"drbonne" wrote:
Have downloaded data with first and last names lumped together in one cell.
Is there a way to have excel split the first and last name into two separate
cells?
|