Extraction and combination from cells

**GREENPIN** · 11-17-2011, 11:54 AM

Hi Excellent people!

I am trying to perform a basic for Excel but not able easily find the solution:

There are two columns of data (see example below) and neede to extract
several positions of text from the both columns and combine via . in third.

column A column B result needed
01A B04-01 S.B4-01.1A

I am struggling with selection of position from the cell. Do I use f-finction?

- What type of function should I use?
- How to select the specific position?
- And shoud I use add function then?
- There is also "." separator required

Please, let me knpw how to do this!?
If you don't know a link or advise me
There is a doftware which does' this
renaming file names, but not content

Please, respond to this thread or send directly to my mailbox. Thanks all!

**NBVC** · 11-17-2011, 12:00 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Also, please do not post email addresses, unless you want spam!

**edvwvw** · 11-17-2011, 12:03 PM

if the data always comes in the same format then the solution is straight forward:

="S."&B1&"."&MID(A1,2,2)

If the number of letters, digits changes then the formula would have to be revised

edvwvw

**arthurbr** · 11-17-2011, 12:06 PM

Please do not invite members to answer your quest by e-mail.

The forum is for helping everyone, not only the poster.

I have removed your e-mail address

**GREENPIN** · 11-17-2011, 01:34 PM

NBVC & edvwvw & arthurbr,
thank you, thank you, thanks
Very changed Excell attitude!

IT WORKED, Only after 5 min help search and 10 min tube crush training, 15min trying - it WORKS!
And don't know yet how to attach the dummy spreadsheet, anyway pasting the results we reached!
Kind regards!!! Now I can quickly do this for other 25 stories! Feel like the man who saw a rainbow

="S."&LEFT(D19,FIND("-",D19)-1)&"."&C19 such a simple code but makes all MAGIC!

Basement 4 01A B04-01 Electrical Cabinet S.B04.01A
01B B04-01 Electrical Cabinet S.B04.01B
01C B04-01 Electrical Cabinet S.B04.01C
02A B04-02 Lobby AOR B04.02A
02B B04-02 Lobby AOR (Riser) B04.02B
003 B04-03 Stair 1 B04.3
004 B04-04 Stair 2 B04.4
05A B04-05 Lobby B04.05A
05B B04-05 Lobby B04.05B
05C B04-05 Lobby (Riser) B04.05C
05D B04-05 Lobby (Riser) B04.05D
05E B04-05 Lobby (Riser) B04.05E
006 B04-06 Electrical Room S.B04.6
07A B04-07 Office Lobby B04.07A
07B B04-07 Office Lobby B04.07B
008 B04-08 FTR Room B04.8
009 B04-09 Residential Lobby B04.9
010 B04-10 Goods Lobby B04.10
011 B04-11 Security Equipment Room B04.11
012 B04-12 Water Feature Equipment B04.12
013 B04-13 Car Park Extract Room B04.13
014 B04-14 Retail Lobby B04.14
015 B04-15 Stair 3 B04.15