Combining columns together while adding new information

Question

My problem is I want to combine two columns together that have city and state but i also need to add a comma and a space in front of the state &nbsp;this is for like 6000 plus cells, i would like to be able to do this all at once or add comma and space first for column b then combine columns togeather i.e&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;End Resultnashville &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tn &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nashville, TNbelleville &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; il &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Belleville, IL&nbsp;&nbsp;Thank You for your help.

wyn hopkins · Answer

Hi Ryan&nbsp;=PROPER(A1)&amp;", "&amp;UPPER(B1)

haytham amairah · Answer

Hi Rayn,&nbsp;Use this formula:=PROPER(A2)&amp;", "&amp;UPPER(B2)

deleted · Answer

Thanks for all the help ended up using =concatenate(B:B,C:C) and then scrolled over D column hit ctrl+enter and wala i ended up using the same formula to add the comma and space just took an extra stepp and used paste special value to just keep text and not formula thank you so much for taking the time to answer my question.

detlef_lewin · Answer

Ryan,&nbsp;use Flash Fill.&nbsp;

sergeibaklan · Answer

Yes, that's exactly Flash Fill&nbsp;was done for.

Forum Discussion

Combining columns together while adding new information

Share

Resources