CELLS

E

Elvis Teran

Hello -
I'm looking to take some data that is all in one cell and
putting them in different cells. How can i do this?
 
F

Frank Kabel

Hi
as a starting point (as you haven't provdied that much info): use
'Data - Text to columns)
 
G

Gord Dibben

Hard to say without more detail, but Data>Text to Columns may do the trick.

Gord Dibben Excel MVP
 
D

David McRitchie

Hi Elvis,
Text to columns is for splitting the contents of a cell
among itself and the cells to right either by a delimiter(s),
or by character position.

If you are trying to put the same value into each of
several other cells you would use assignment.
B3: =A1
B14: =A1
 
Top