How to take from 5th letter to the front?

**Pbox7** · 01-20-2009, 07:59 AM

let me explain:

1 colunn

234567-roma
345697-new york
431414-lancsternshein
413444-madri

I need to take the name of the city to another colunn like this:

1º colunn 2º colunn
234567 roma

how I do that?

thanks

**sweep** · 01-20-2009, 08:06 AM

These formulas will split the data as you have requested.

=LEFT(A1,FIND("-",A1)-1)

=RIGHT(A1,LEN(A1)-FIND("-",A1))

**arthurbr** · 01-20-2009, 08:10 AM

A solution without formulas :
Data - text to columns
Select "Delimited"
Input "-" ( no quotes) as delimiter
Finish

( if you always have 6 numbers followed by the dash, the " Fixed width" option might also do the job but you'll be left with a third column with the dash

**mudraker** · 01-20-2009, 08:10 AM

Another option
Select data
Data menu
Text To Columns
Delimited option
Tick Other Checkbox & remove tick from all other checkboxes
enter - in the box to the right of the Other checkbox
Next
Set column data format if required
Finish button

**Pbox7** · 01-20-2009, 08:19 AM

thanks people,

Pol

**mudraker** · 01-21-2009, 08:14 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

How to take from 5th letter to the front?

LinkBack

Thread Tools

Rate This Thread

Display

How to take from 5th letter to the front?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions