Forum Discussion
Combining columns together while adding new information
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 this is for like 6000 plus cells, i would like to be ab...
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.