How to move data in excell? Closed

Question

Hello, 

I would like to separate data in one excell cell into two excell cells e.g. 
241 GOLD CREEK RD, BROOKFIELD, QLD 4069 in one cell into 241 GOLD CREEK RD in one cell and BROOKFIELD, QLD 4069 in a second cell.

Thank you.

Configuration: Windows XP / Internet Explorer 8.0

aquarelle · Answer

Hi,

I supposed that your cell containing "241 GOLD CREEK RD, BROOKFIELD, QLD 4069"  is A2. Use the following formula for B2 and C2.

B2=LEFT(A2, FIND(",",A2,1)-1)
C2=RIGHT(A2,LEN(A2)-FIND(",",A2,1)-1)

Best regards

How to move data in excell?

1 response

Similar discussions

Subscribe To Our Newsletter!