Changing text from one column to another

**alexaskmo** · 08-09-2013, 09:25 AM

Okay i need som help, my excel asks for ";" seperators and everyone on this forum seems to use "," Help me find the right seperators please, i only get wrong formula results.

**amy_d2** · 08-09-2013, 09:29 AM

This is because of difference in language, Check if this works for you

=IF(ISERROR(SEARCH("Expedition";A1;1));IF(ISERROR(SEARCH("Genomfört";A1;1));A1;"Genomfört");"Expedition")

**alexaskmo** · 08-09-2013, 09:32 AM

Amy, Thanks a million!! you just solved my problem!! would you mind explaining the coding and what it does for future use?

Again!! THANKS

Oh!! also, is there a way for excel to understand that i want the formula to e applied to the whole of the new column? (for when the data gets larger so that it's done automatically. Thanks again!