Extract data from one cell into 2

  • Thread starter Thread starter SSolano
  • Start date Start date
S

SSolano

User has a column that includes suite numbers in an
Address1 column.

Want to extract the suite number and place in a newly
created column called Address2.

I've done this before, but can't remember.

Any suggestions?
 
I think we need a little more info, i.e, position of the suite number. This
will grab the last four digits. Copy to the address 2 column.

=TRIM(IF(LEN(A1>4,LEFT(A1,LEN(A1)-4),""))
 
-----Original Message-----
User has a column that includes suite numbers in an
Address1 column.

Want to extract the suite number and place in a newly
created column called Address2.

I've done this before, but can't remember.

Any suggestions?
.
Click to expand...
1) You can copy and paste it from one cell to the other.
2)put your mouse on the bottom-right corner of the cell
until the pointer sign changes, then drag it onto the
other column.
3) type in a formula that makes the address cells in
address2 column equal to those in address1 column.
 
Back
Top