How can I copy specific content from other cells? (excel 2000)

Topic

New Reply

Is there a way to copy specific content from one cell to another? For example; the content in one cell is “AKRON 120 – SNSET 120 – 1”. How can I write a command that will allow me to write “AKRON-SNSET – 120” into another cell without having to write it myself in this fashion (very long list). There are the same amount of characters and symbols in each cell that is decribed above.

Thanks

LaMont

Reply | Quote

Replies

Hi LaMont

If I understand correctly, all cells are in the format “XXXXX NNN – XXXXX NNN – N” If so the following will work.
=LEFT(A1,5) & “-” & MID(A1,13,5) & ” – ” & MID(A1,19,3)

Reply | Quote

Thanks alot – works perfect!

LaMont

Reply | Quote

Thanks alot – works perfect!

LaMont

Reply | Quote

Hi LaMont

If I understand correctly, all cells are in the format “XXXXX NNN – XXXXX NNN – N” If so the following will work.
=LEFT(A1,5) & “-” & MID(A1,13,5) & ” – ” & MID(A1,19,3)

Reply | Quote