Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I copied a text from a web page to Cell A1 in excel. It looks like as
follows a1=Height (in) 58 59 60 Now I want to separate to into 4 cells as follows: B2=Height )in) B3=58 B4=59 B5=60 I do remember once I had read a thread related to this issue before but I cant find it now. I think by combination of left and mid functions it is possible to perform this task but the problem is about auto-detection of space between numbers and I cant recall this part. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) |