I have a long (1000+) list of town names for a state and am looking for a function that will allow me to add the same line of text (, state name) to each of the towns. I've been playing around with the "concatenate" function but cannot maniuplate the text in the way I want. Any ideas?
More specifically what does your data look like?
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
try:
=A2&", Florida"
copied down.. replacing Florida with actual state... and assumes towns start in A2..
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Try =A2&", "&$B$1if in B1 is state name
b1Where a1 is state name.
Please Login or Register to view this content.
And drag down below.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Awesome, the &",state" worked perfectly, very simple, appreciate the help, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks