Seperating information in a cell

W

WBWootton

I would like to seperate the data in a cell into individual cells

Data in cell is
ACTR,24VAC,CAPP,332898
I want to seperate out the data by the comma (,)
The end result would be
Cell 1 = ACTR
Cell 2 = 24VAC
Cell 3 = CAPP
Cell 4 = 332898

The number of characters varies and the comma can be in or out of the end
result cells
 
L

Luke M

First, highlight the cell(s) in question.

Under Data, go to Text-To-Columns. Choose delimited, and then select the
comma as your delimiter. Click finish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro help 2
Cut some of the data in a cell and move to the neext cell 4
VBA Excel partial cell compare to another cell 0
How To Have A Cell Be Blank If... 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel Need Countifs Formula Help 0
Excel VBA 1

Top