Forum Discussion
Solved
Split name, address and city
Hi, Could anyone please help with the following? I need to split the name from the address and the city from the address. The format is the following Jane Doe 1234 Main Street New York It n...
Hi alekssimic,
I would use the simple flash-fill principles here.
Just format all the information you need as a table, insert one example across like you did in your question, and then select CTRL+E to flash-fill down the column. I created two other examples and it all worked quickly for me. Example attached, I typed across the first row and then flash-filled down.
Hi alekssimic,
I would use the simple flash-fill principles here.
Just format all the information you need as a table, insert one example across like you did in your question, and then select CTRL+E to flash-fill down the column. I created two other examples and it all worked quickly for me. Example attached, I typed across the first row and then flash-filled down.
Amazing! Thank you.