Remove characters

Hello,
I just need "simple" thing - here is datas

Please Login or Register  to view this content.

and I need to remove all characters, so after that It should be :

Please Login or Register  to view this content.

I can do it through replace function (character by character ) but it's not solution what I need. Will somebody help me please? Thank you

To Grab the numbers you could pick the Code Right for you. This is Formulas that you could quickly sort through a table of data that shows the exact same formating.

C49 = Cell of Original Data
-3 = Trim
5 = Grab

Please Login or Register  to view this content.

- Trim the Last 3 Chars

Please Login or Register  to view this content.

- Trim the First 3 Chars

Please Login or Register  to view this content.

- Grabs the First 5 Chars

Please Login or Register  to view this content.

- Grabs the Last 5 Chars

HOWEVER!!!

This is what I would Recommend Doing.

Please Login or Register  to view this content.

Where as this Code is Going in D49

C49 = Janko 10:20
E49 = 5
D49 = 10:20

there are 5 Characters the " : " and the for numerical characters.

Since the Formula is set to C49 and E49 - Where C49 is your Static Information and E49 is your Dynamic Information We would Have another Example as.

C50 = Vianoce 154,75
E50 = 6
D50 = 154,75

To get to D50 all you had to do was count that there are 6 Characters in C50 on the right side that you wanted to Keep. ^_^

If your data starts in A1 you can also try

Please Login or Register  to view this content.

copied down

The only way of doing your last request that I know of is to use a macro. There is an example below (Not one that I wrote). Select the cells you wish altered and then run the code. Beware only select the cells you want altered and not entire columns as it will loop for ages.

Please Login or Register  to view this content.

Assuming your data is in A2 down try this in B2

Please Login or Register  to view this content.

Hope this helps.