Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trim Multiple items in one column

Status
Not open for further replies.

Cpreston

MIS
Mar 4, 2015
972
GB
Hi

I have a large spreadsheet that as one column with all the information. I want to spilt the data into different columns before and after a ; appears (example line below). I have looked for Trim commands on google but cannot find anything quite what I am after. Could some assist please. Thanks in advance

26413;RB/8277240792;FSC Mix Credit;RW BC;30x148;5400;223;5.347
 
Hi

Its ok managed it I used =TEXTSPLIT(A2,";")

Thanks
 
You could also do - highlight column with your data and:
Data - Data Tools - Text to Columns... - Delimited - Semicolon - Text

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top