Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default extraction

hi community

i have these data :

A B C

1 A. Yamamoto

2 Q. C. Carver

3 O. Sanchex

4 F. X. Layman

how can i extract and have it as in B column as:

A B C


1 A. Yamamoto Yamamoto A.

2 Q. C. Carver Carver Q. C.

3 O. Sanchex Sanchex O.

4 F. X. Layman Layman F. X.

thanks community for the assistance

:)


--
oldLearner57
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extraction Martina Excel Worksheet Functions 4 May 24th 07 04:48 AM
Word Extraction A.S. Excel Discussion (Misc queries) 3 May 5th 06 06:27 PM
data extraction TUNGANA KURMA RAJU Excel Discussion (Misc queries) 10 February 27th 06 12:25 PM
data extraction Usul New Users to Excel 1 February 16th 06 04:04 AM
Data Extraction Chicken Man Setting up and Configuration of Excel 1 February 24th 05 03:13 AM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"