In Excel, I have a column with City, State, and Zip codes combined. A comma does not separate the data so text to columns will not work.

To analyze the data by city or state or zip, I need to break them out into three separate columns. I'm going to use the Text Functions Left, Right, and Len to handle this.

The reason Text to Columns will not work is the data is displayed without a comma.
Atlanta GA 30304
New York NY 11111
San Diego CA 99922

Left Function
**************
LEFT returns the first character or characters in a text string, based on the number of characters you specify.
Example: if A1 contains GA-201. In B1 type =left(A1,2) and press Enter. It will return GA in B1. It pulled two characters from the left.

Right Function
**************
A1 still contains GA-201. In C1 type =Right(A1,3) and press Enter. Cell C1 will show 201. It pulled three characters from the right.

[ Ссылка ]
A free course of Ten Reasons to use Tables in Excel
[ Ссылка ]

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

свернуть