combined number into three separate columns

[nancy.darnell]

Hi

I have a combined numbers in a field separate by x. For example

12 X 14 X 1.5. I need help use a funtion or macro to put each the number in three separate columns. Please help, thanks

Nancy

 

[jindon]

UDF

1) paste the code onto a standard module
2) use in cell
select 3 horizontally consecutevie cells like B1:D1
=nancy(A1)
then confirm with Ctrl + Shift + Enter (array formula)

Function nancy(txt As String)
Dim x
x = Split(txt, "X")
nancy = Array(Trim(x(0)), Trim(x(1)), Trim(x(2)))
End Function

 

[pgc01]

Hi Nancy

You can use Data>Text to columns with the delimeter x .

Hope this helps
PGC

 

[nancy.darnell]

Text to columns works great. thank you very much

Nancy