SOLVED

Separating Text

Copper Contributor

Hello, I'm an Excel novice and would love any assistance you may be able to offer please. I am trying to separate the text in column A into individual cells. I have done it manually in Row 1 to show what I require. I'm familiar with Concatenate to put them back together, just not how to separate. Punctuation is not required, but not necessary to remove either. Thank you in advance for any suggestions you may have :)  

 

Untitled 3.jpg

3 Replies
best response confirmed by zipcoop (Copper Contributor)
Solution

@Detlef Lewinwell now I'm feeling quite stupid at how easy that was!! Thank you so much, I really appreciate it, cheers 

Text to Column will separate the text values
1 best response

Accepted Solutions
best response confirmed by zipcoop (Copper Contributor)