Extracting Words From Within a Cell

G

Gettingbetter

Well-known Member

Joined

Oct 12, 2004

Messages

602

• Dec 6, 2006

• #2

Hi,

If you highlight your cells,

Then from the toolbar click,
Data | Text to columns

You should get a Convert text to columns wizard box,

Make sure Delimited is selected, then click next,
now put a tick in Space, now click finnish.

That should kind of give you what you want.

Cheers
Paul

 

Upvote 0

B

bradh_nz

Board Regular

Joined

May 23, 2006

Messages

92

• Dec 6, 2006

• #3

Hi

Thanks, yes this would normally work but the cell have the spaces in them by using ALT-Enter and it will not pick them up.

Thanks
Brad

 

Upvote 0

shades

Well-known Member

Joined

Mar 20, 2002

Messages

1,550

• Dec 6, 2006

• #4

Howdy. You do a find/replace to get rid of the new line break. Find CHAR(10) and replace with a space.

 

Upvote 0

K

Krishnakumar

Well-known Member

Joined

Feb 28, 2003

Messages

2,615

• Dec 6, 2006

• #5

Check other and hit Alt+010

 

Upvote 0

B

bosco_yip

Well-known Member

Joined

Dec 2, 2002

Messages

1,947

Office Version

1. 2019

Platform

1. Windows

• Dec 7, 2006

• #6

....CURRENT
Cell A1 CIO-SPCH-31-01 CIO-APCH-31-02 CIO-ESSC-31-01
Cell A2 CIO-SAOP-32-01
Cell A3 CIO-IPOP-32-01

OUTPUT REQUIRED

Cell B1 CIO-SPCH-31-01
Cell B2 CIO-APCH-31-02
Cell B3 CIO-ESSC-31-01
Cell B4 CIO-SAOP-32-01
Cell B5 CIO-IPOP-32-01......

Click to expand...

1] Put your mouse pointer on the top of column header, between A and B

2] Click and move the pointer left, then reduce the column A to width : 7.00 (54 pixcels)

3] Select A1:A3 >> Edit >> Justify >> OK

Hope that helps

Regards

 

Upvote 0