How would I do this?

[Martin ©¿©¬]

Hi
I'm preparing a spreadsheet to be used as a data source for labels
THE WHITE LADY (Co. Antrim Coast) Watercolour Mrs C. Bones £90.00
(4 COLUMNS

There are several entries like this where the title is too long for
the label with my desired font

How would I, or is it possible to have
THE WHITE LADY
(Co. Antrim Coast) in the first column & the other colums as-above,
so that when I import the data (into Publisher) it will arrive in my
desired layout?

 

[Francis]

Have you try using the Text to Column under Data on the Tool bar?

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another

 

[Martin ©¿©¬]

Have you try using the Text to Column under Data on the Tool bar?

That didn't do what I wanted?

 

[GIS Tech II]

This may be an overly simplified solution, but have you tried using word wrap
in that one cell alone?